VBA Syntax

J

JL

I am trying to check if a Date field is null, and I can't seem to get
the syntax right. I have tried the following 3 ways:

If Forms![FormName]![Date] Null Then
If Forms![FormName]![Date] Is Null Then
If Forms![FormName]![Date] IsNull Then

Thanks for your help.
JL
 
J

Joan Wild

If IsNull(Forms![FormName]![Date]) Then

I suggest you don't have a field or control named Date as that conflicts
with a function name in Access.
 
Top