Date Field empty if statement

[dubsdj]

Hi, Im trying to check if a date has been entered in a field in an Access form.

I tried this:



If IsNull("Return Date") Then
MsgBox "Field is empty"
Else
MsgBox "Field is not empty"
End If

but it says the field is not empty when it actually is empty.

Thanks

[pbaldy]

You're not testing the field, you're testing the literal text string "Return Date", which will never be Null. Try

If IsNull(Me.[Return Date]) Then

[dubsdj]

If IsNull(BegDate) Or IsNull(EndDate) Then


seems to work for me

[RuralGuy]

I take it you want to thank Paul for his suggestion and then use the Thread Tools and mark this thread as Solved, yes?

[pbaldy]

You can typically get away with that, but I prefer being more specific. Is BegDate a field, control or variable? You can't tell from that.