Date field on form

marathonlady

Registered User.
Local time
Yesterday, 22:27
Joined
Jul 10, 2002
Messages
120
I have several date fields on my form. I need to check if there is a date in a field. My code is: if isnull(datefield), then...

Problem is there is a date in the field but it thinks it's a null all the time. Any way to resolve this?

Thanks in advance for your help.
 
I've used

if me!FieldName & "" = "" then

works on a bound or unbound field.
 
Try IsDate instead of IsNull
 

Users who are viewing this thread

Back
Top Bottom