IsNull not working...

[Moekandu]

This is a weird one, and I've never seen this kind of behavior.

...
If IsNull(SearchRST.Fields(2)) Then
    SuccessBOOL = False
    Debug.Print "Null!"
Else
    CompareARY = ParseStringCRLF(SearchRST.Fields(2))
    For j = 0 To LineLimitINT
    ...

When the IsNull function returns True, it doesn't flow to the true section, instead it keeps jumping to the Else.

In the immediate window, I can type:

? isnull(SearchRST.Fields(2))
True

And I get the correct response. Why is the program not flowing correctly? Am I crazy?

Thanks for your help.

[RuralGuy]

Start by *importing* everything to a new fresh db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew

[Moekandu]

That worked.

[RuralGuy]

Great! Go ahead and use the Thread Tools and mark this thread as Solved.