>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.
>

I don't use the controlsource for situations like this, I 'custom' bind the control by putting code in the refresh and valid methods:

Refresh:
THIS.Value = TTOD(THISFORM.oRS.Fields("myDateTime").Value)

Valid:
THISFORM.oRS.Fields("myDateTime").Value = DTOT(THIS.Value)