Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_GeneralGeneral Functions

Public Function zn (
i As Variant
) As Variant

The opposite of the nz() function: returns null if value is null, empty string, 0 or "0". Used for reports to suppress display of zeroes, making relevant information stand out

i as Variant

A variant value

Call Template:

Dim v As Variant
v = xf.Gen.zn(i)

See Also:

Example 1:

zn(Null)   => Null
zn(0)      => Null
zn("")     => Null
zn("0")    => Null
zn(23)     => 23
zn(1.566)  => 1.566
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd