<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=606381800-07032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Well supposedly 2002 handles Nulls differently from earlier versions, but
I've seen no evidence of it. However, if you used Len(<expression>)
in 2000 and earlier, and the expression was Null, you got an error, so you had
to use Len(<expression> & "") to avoid the error. I haven't
tried it yet, but I can't say that I trust it.</FONT></SPAN></DIV>
<DIV><SPAN class=606381800-07032003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=606381800-07032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com]
<B>On Behalf Of </B>David McAfee<BR><B>Sent:</B> Thursday, March 06, 2003 3:03
PM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE:
[AccessD] Nz function in Access 2002<BR><BR></FONT></DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff
size=2>Hmmm, in A97, I made a new form. Created the following
sub:</FONT></SPAN></DIV><SPAN class=483554922-06032003>
<DIV><FONT face=Arial color=#0000ff size=2></FONT><FONT face=Arial
color=#0000ff size=2></FONT><FONT face=Arial color=#0000ff
size=2></FONT><BR><FONT face=Arial color=#0000ff size=2>Private Sub
Form_Load()<BR>MsgBox "Len(me.openargs) =" &
Len(Me.OpenArgs)<BR>Stop<BR>End Sub</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff size=2>The
msgbox displays "Len(me.openargs) ="</FONT></SPAN></DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff size=2>so,
I press Ctrl+G, and enter the following in the debug window and get the
following results:</FONT></SPAN></DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff
size=2>?Len(me.openargs)<BR>Null<BR>?Len(me.openargs)>0<BR>Null<BR>?Len(me.openargs)=0<BR>Null<BR>?Len((me.openargs))<BR> 0
<BR>?isnull(me.openargs)<BR>True<BR>?isempty(me.openargs)<BR>False<BR>?nz(me.openargs)</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff
size=2>?nz(me.openargs,0)<BR> 0
<BR>?nz(me.openargs)=""<BR>True<BR>?nz(me.openargs,"")=""<BR>True<BR></FONT></SPAN></DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff size=2>It
seems to me that the MS Len fix wouldn't work for OpenArgs (or lack there
of) validation</FONT></SPAN></DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff size=2>Can
someone try this in A XP (2002)?</FONT></SPAN></DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=483554922-06032003><FONT face=Arial color=#0000ff
size=2>David</DIV></FONT></SPAN>
<DIV><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com]<B>On Behalf Of </B>Charlotte
Foust<BR><B>Sent:</B> Thursday, March 06, 2003 1:01 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Nz function in
Access 2002<BR><BR></FONT></DIV>
<DIV><SPAN class=895415920-06032003><FONT face="Comic Sans MS" color=#0000ff
size=2>But they don't need a fix, Charles. After all, they posted a
"resolution" in the article! <vbg> I'd just be happy if they
explained what it is that doesn't work!!</FONT></SPAN></DIV>
<DIV><SPAN class=895415920-06032003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=895415920-06032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Wortz,
Charles [mailto:CWortz@tea.state.tx.us] <BR><B>Sent:</B> Thursday, March
06, 2003 12:40 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Nz function
in Access 2002<BR><BR></FONT></DIV>
<DIV><SPAN class=321013820-06032003><FONT color=#0000ff size=2>I did a
check of kbAlertz and there is no follow-up KB article posted yet.
So whatever is the unstated problem with NZ(), they haven't posted a fix
yet.</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas
Education Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>1701 N. Congress Ave</FONT></SPAN> <BR><SPAN
lang=en-us><FONT color=#0000ff>Austin, TX 78701-1494</FONT></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>512-463-9493</FONT></SPAN>
<BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> William
Hindman [mailto:wdhindman@bellsouth.net] <BR><B>Sent:</B> Thursday 2003
Mar 06 14:27<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
Re: [AccessD] Nz function in Access 2002<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>...this is a prime example of
Microsoft geek writing ...the reason I never buy anything from MS
Press ...I'll be damned if I can figure out what it is that the nz
function doesn't quite perform "as expected"? :(</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...I use nz in several AXP apps and to date
have noticed nothing that I didn't expect ...but with this kind of crap
KB, I'll be certain to waste a lot of time the next time I use it, just
futzing about looking for some kind of error in the returned data
:(((((</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...I don't know whether to thank Charlotte
for pointing this out or mail her my dirty laundry instead :(</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman ...ok, I won't mail her my dirty laundry ...probably
upset my post lady :)</DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=cfoust@infostatsystems.com
href="mailto:cfoust@infostatsystems.com">Charlotte Foust</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=AccessD@databaseadvisors.com
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, March 06, 2003 1:56
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Nz function in
Access 2002</DIV>
<DIV><BR></DIV><!-- Converted from text/rtf format -->
<P><FONT face="Comic Sans MS" size=2>I ran across an MSKB article today
</FONT><A
href="http://support.microsoft.com/default.aspx?scid=kb;en-us;295619"><U><FONT
face="Comic Sans MS" color=#0000ff
size=2>http://support.microsoft.com/default.aspx?scid=kb;en-us;295619</FONT></U></A><FONT
face="Comic Sans MS" size=2> that says the Nz function works in 2002 but
it may not work as expected! Say what?? It works, but
it doesn't?</FONT></P>
<P><FONT face="Comic Sans MS" size=2>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?</FONT></P>
<P><FONT face="Comic Sans MS" size=2>Charlotte Foust</FONT>
</P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>