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
It's "my" world. You're just living in it.