G Guest Mar 31, 2005 #1 Format does not handle a null value calculation with formating for nulls, e.g. Format(Null/1,"0.0;;;0") returns 128 0's
Format does not handle a null value calculation with formating for nulls, e.g. Format(Null/1,"0.0;;;0") returns 128 0's
G Guest Mar 31, 2005 #2 Conceptually I am not sure how you would format a null. Trap the null & handle it separately. The Nz() function may be of interest Terry
Conceptually I am not sure how you would format a null. Trap the null & handle it separately. The Nz() function may be of interest Terry
A Allen Browne Mar 31, 2005 #3 In what context? In the Immediate Window (Ctrl+G), your expression returns a single zero in my test, and this returns the L you would expect: ? Format(Null/1,"0.0;;;\L")
In what context? In the Immediate Window (Ctrl+G), your expression returns a single zero in my test, and this returns the L you would expect: ? Format(Null/1,"0.0;;;\L")
