[AccessD] compare nulls

Jim Lawrence accessd at shaw.ca
Wed Jan 17 13:34:54 CST 2007


Mark:

Try 

IF me!text1 & "" = me!text2  & "" then...

Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Wednesday, January 17, 2007 8:20 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] compare nulls

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




More information about the AccessD mailing list