A2003 bug with format()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

e.g. Format(Null/1,"0.0;;;0")
returns 128 0's
 
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
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Union Query Help 5
Data Validation 1
Add 1 field to query 1
Can't edit form data from stored procedure 1
call function module from query - having much trouble 8
Custom Number Format for text 8
Using COM objects in .NET 2

Back
Top