My code starts Nz(DLookup... and I've never seen that prefix before Thanks
R Roger Carlson Jun 17, 2004 #2 It is the NullToZero function. It will convert any Null returned to a zero (or some other value if you so specify). This is important because most VB variables will not accept Null as a value. The single exception is the Variant variable type.
It is the NullToZero function. It will convert any Null returned to a zero (or some other value if you so specify). This is important because most VB variables will not accept Null as a value. The single exception is the Variant variable type.
