Dates

[santastefano]

I have a bound box on a form, the box is formatted as a date.
On exit from the box I want to check that there is some entry and produce an error message if the box is empty "You must enter a date here..."
I have been trying if / then statements and have attempted every format I can think of
if StartDate (the name of the box) = #__/__/____# then etc. etc.
I know there must be a simple answer to this but I can't find it here or in any of my reference books.
If anybody can help....?
Thanks in advance
George

 

[PHV]

And what about something like this ?
If Not IsDate(StartDate) Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[santastefano]

Thanks PH for your quick and, more importantly, excellent solution