Hang on...
It works fine for numbers but not dates!
Since SQL Server does not have a date field type (only a datetime), the ADO field is a datetime and does not honor the '99/99/9999' Input Mask setting. It is showing the time portion as well.
>Never mind!
>
>I was using the Format property to do what the Input Mask property is supposed to do! I need a rest.....
>
>
>>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?