VBA Syntax

  • Thread starter Thread starter JL
  • Start date Start date
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
 
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.
 
Back
Top