A NULL Question

[botts121]

When writing a statement with NULL, what is the opposite of NULL?



Like if I was to write

If City = Null Then City.Enabled = True Else City.Enabled = False

If I wanted to switch that around, what could I use instead of NULL?

If City = (Blank) Then City.Enabled = False Else City.Enabled = True


Thanks,

Matt

[pdouglas]

City <> NULL
or
if NOT(IsNULL(City)) Then

Cavaet - I'm noticing that Access doesn't like to "Play Well" with Non-Variant types and IsNull(). Maybe it is just a local peculiarity.

[RuralGuy]

Just for the record, Null is defined as the absence of anything. Nothing is equal to Null including Null. That is why we have the IsNull() function.

If IsNull(Me.City) Then
   Me.City.Enabled = True
Else
   Me.City.Enabled = False
End If

Or the reverse:

If Not IsNull(Me.City) Then
   Me.City.Enabled = False
Else
   Me.City.Enabled = True
End If