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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query by form problems 6
If/Then useage in a form - what's faster? 5
Access Determine what query to run based on a checkbox 0
Null Value for Blank Date Range 2
Show all records with a keyword ex:"ALL" 3
Filter between two dates 1
Relation between tables in query and criteria 1
Access Building a IIF expression in Access 0

Back
Top