I have taken over a project that was partially completed. It is using SQL Server backend and ADO to communicate to the front end.

The people on the project prior to my taking over, subclassed some controls (textbox, editbox, etc) and made them so that they can be bound to fields in an ADO Recordset.

This all works fine except I cannot get these controls to honor the Format property. I want a numeric field to be formatted '9,999.99'. It always displays with several zeros after the decimal and no comma.

Does anybody know how to make the controls honor the formats?