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>