[AccessD] Nz function in Access 2002

Thanks for the heads up Charlotte, 
 
        The KB article isn't clear. I remember reading somewhere that you
should always use:
             IF NZ(SomeValue,"") <> ""
        rather than
             IF NZ(SomeValue) <> ""
So maybe that's what they are talking about. I don't use AXP yet, only 97 &
2K (which still seem to work for me)
 
David

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte Foust
Sent: Thursday, March 06, 2003 10:56 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Nz function in Access 2002



I ran across an MSKB article today
<http://support.microsoft.com/default.aspx?scid=kb;en-us;295619>
http://support.microsoft.com/default.aspx?scid=kb;en-us;295619 that says the
Nz function works in 2002 but it may not work as expected!  Say what??   It
works, but it doesn't?

Has anyone run into this?  Nz isn't always the most appropriate function,
but I've never seen it fail, at least not that I knew about.  We use this a
lot, and I'm concerned about migrating our apps from 97 to 2002 and having a
lot of code fall over.  I wondered if it could be the result of not passing
in the optional argument, but the article seemed rather vague to me.  Does
anyone else have first-hand knowledge of the problem?

Charlotte Foust 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 4817 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030306/9fad0f57/attachment-0001.bin>