[AccessD] Nz function in Access 2002

Gustav Brock gustav at cactus.dk
Fri Mar 7 10:30:01 CST 2003


Hi Charlotte et all

>> I ran across an MSKB article today
>> 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! ..

Well, this quote (below) from the same link looks even more
surprising!
Why should IsNull(nullvalue) not evaluate to True??

I don't have A2002. Can anyone confirm this?

/gustav

<quote>

There are other methods that check for Null values as well. They are
illustrated below. However, these methods cannot be used as valid
workarounds to the Nz Method problem.  
None of the following methods will evaluate to True, even when the Fax
value is Null:

If Fax.Value = Null Then
    ...
End IF


If IsNull(Fax.Value) Then
    ...
End If


If IsEmpty(Fax.Value) Then
    ...
End If

</quote>




More information about the AccessD mailing list