Hi John,
Unfortunately, at this very moment I can't test this solution, but simple test in MS Access produced:
? datevalue("12/01/2000 17:00")
12/1/2000
? datevalue("17:00")
12:00:00 AM
Just my 2 cents.
HTH, Igor
>Thanks Igor. But this still means I have to code similarly right?
>
>If DateValue(RS.Fields("MyDateField")) = ""
> txtShipDate.Value = ""
>Else
> txtShipDate.Value = RS.Fields("MyDateField").Value
>End If
>
>
>
>>
>>Hi John,
>>
>>In VBA you can use function DateValue which gives the date part of the datetime value. Check Date part of the datetime value.
>>
>>HTH, Igor
Igor Gelin
Database Developer