A2003 bug with format()

G

Gordon

Format does not handle a null value calculation with formating for nulls,

e.g. Format(Null/1,"0.0;;;0")
returns 128 0's
 
T

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

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")
 
Top