[AccessD] compare nulls

<student looking at ground pushing imaginary rock with toe>
Thank you Teacher.
</student looking at ground pushing imaginary rock with toe>

>From: "Gustav Brock" <Gustav at cactus.dk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] compare nulls
>Date: Wed, 17 Jan 2007 17:31:29 +0100
>
>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
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Get live scores and news about your team: Add the Live.com Football Page 
www.live.com/?addtemplate=football&icid=T001MSN30A0701