[AccessD] compare nulls

Hi Mark 

<rising teacher's finger in the air>
That's because Null is undefined - it cannot be equal to anything.
</rising teacher's finger in the air>

You can use IsNull() to check that condition, or wrap the textboxes in Nz()

/gustav


>>> markamatte at hotmail.com 17-01-2007 17:20:09 >>>
Hello All,

I have 2 text boxes I need to compare to see if they are equal...but if they 
are both null it does not match.  In the example below if text1 and text2 
are both null...it says not equal?  I'm sure its easy to get around 
this...or is this even normal?

IF me!text1=me!text2 then
msgbox"Equal"
else
msgbox"Not Equal"
end if

Thanks,

Mark