>>
>>Convert to date. Look at functions TTOD() and DTOT()
>
>OK, stupid question time..... If you have a database in the dataenvironment of
>a form, the field has datetime as the datatype, and you drag and drop the field
>on to the form... how can you convert to a date? I used to understand this
>when we used memvars, now...?
You might want to unbind the control, so that the .ControlSource is blank. Then, in the txtDate.Refresh(), you can set
This.Value = TTOD(myTable.tEvent)
, and the LostFocus can contain a REPLACE statement to go the other way.