[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
>
> _________________________________________________________________
> The MSN Entertainment Guide to Golden Globes is here.  Get all the scoop.
> http://tv.msn.com/tv/globes2007/?icid=nctagline2
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com