During class last night we encountered something that I am curious about and I’m wondering if anyone here has the answer.

The code snippet below is what is causing the dilemma.

***********
Do Until adorecordset.EOF
'If adorecordset!Name <> Null Or adorecordset!Name <> "" Then
If Not IsNull(adorecordset!Name) Then
List1.AddItem adorecordset!Name
End If
adorecordset.MoveNext
Loop
***********

The commented out IF test is what my instructor gave us.

The OR part of the IF statement is required for the body of the IF statement to be executed.

The ISNULL function does not have this glitch.

Logically the “ <> Null ” and the “ Not IsNull()” are the same. RIGHT??

The database is BIBLIO.mdb.

Any thoughts??