Conditional IF for empty fields with no dates

[charly.csh]

Hello everyone,



Maybe my question is little simple this time, but how should be the correct statement for a "field date" as empty I mean


I want to get this.... "If Me.Date_Real = "" Then MsgBox "Good"


This is not making nothing and I understand maybe it the wrong statement but how should be it corrected?

********************************

If Me.DateReal <> "" Then


Dim MessageBox As Integer


MessageBox = MsgBox("Do you want to close", vbYesNo, "Q-Tool ***Actions")


If MessageBox = vbYes Then


Me.Status = 1


ElseIf MessageBox = vbNo Then


Me.DateReal = ""


End If


End If



Thanks for the support!!!

[pbaldy]

To test for no date:

If Not IsDate(Me.DateReal) Then

You could also test for Null

If IsNull(Me.DateReal) Then

[charly.csh]

Great!
That was the solution!

Thanks!!!

[pbaldy]

Happy to help!