MS Access How can I check for a text value in a null value field?
Posted on 2013-01-29
This code works fine until I added the piece in bold:
Private Sub Project_Name_AfterUpdate()
If "" & Me.ProjectName <> "" And IsDate(Me.AendDate) = False And Me.Status <> "Cancelled" Then
Me.Status = "Working"
This statement doesn't work due to a null value in the Status Field.
(Only works with existing text in the Status field)
How can I check for text "Cancelled" in a null value field?