how can you tell if a date field is null? 1

[tziviak]

I have a date field-set to shortdate and in my code I'm trying to test it if it's null-in an if statement-but the problem is that it never tests as null (although the field is empty) -it always executes the else part of the statment.
is there another word to use instead of null-since it's a date field?
my code is:

If rec.Fields("DateReceived&quot = Null Then
MsgBox "deleted"
rec.Delete
Else
MsgBox "date received" & rec.Fields("DateReceived&quot.value
End If


thank you

 

[Norris68]

If IsNull(rec.Fields("DateReceived&quot) Then
MsgBox "deleted"
rec.Delete
Else
MsgBox "date received" & rec.Fields("DateReceived&quot.value
End If

 

[tziviak]

thank you-it worked