[RESOLVED] [Access 2002] Null evaluating to true in opposite comparisons

[sevenhalo]

I have the following code:

Private Sub Form_Load()
    If Me.OpenArgs = Null Then       
        DoCmd.GoToRecord , , acNewRec
    Else                               
            'Do something else
    End If
End Sub

Everytime I step through it, it drops to the else clause. If I flip the comparison to:

Private Sub Form_Load()
    If Me.OpenArgs <> Null Then       
        DoCmd.GoToRecord , , acNewRec
    Else                               
            'Do something else            
    End If
End Sub

It still drops to the else clause. I checked the value of Me.OpenArgs to see what it actually is:


What am I doing wrong here? How can it not be either true or false?

My first thought was that Null is only used to compare objects (like in VB.Net), but the immediate value told me otherwise.

Thanks!