Testing for blank dates????

[Caro]

I have an Access database with a date field - this does not have to be present. How do I test for null date??

[RealisticGraphics]

All you have to do is something like this:

'Looking at it in a form field of some kind.
if MyField = "" then
   msgbox "It's Empty"
else
   msgbox "It's not empty"
endif

or

'Looking at it in a query using sql
Select * from MyTable where MyField = Null;

That's all there is to it.

[cas21]

if not isdate