[AccessD] compare nulls

Dan Waters dwaters at usinternet.com
Wed Jan 17 10:58:42 CST 2007


Hi Mark,

Would this work?

If IsNull(txt1) and IsNull(txt2) Then
	Do this
Else
	Do that
End If


Dan Waters

-----Original Message-----
Subject: Re: [AccessD] compare nulls

I think the explanation is that Null is nothing and nothing can't be
equal to anything, not even another nothing. Or thereabouts. Perhaps
some IS NULL functions can be added.

GK

On 1/17/07, Mark A Matte <markamatte at hotmail.com> wrote:
> 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
>




More information about the AccessD mailing list