Number formatting...

  • Thread starter Thread starter Dustin
  • Start date Start date
D

Dustin

I am working on a year end report that totals of monthend queries. There are
some categories have a value of 0, but they are left blank. This makes the
report look awkward. Is there a way to format these blank records as a 0?

Any help would be greatly appreciated.
 
I am working on a year end report that totals of monthend queries. There are
some categories have a value of 0, but they are left blank. This makes the
report look awkward. Is there a way to format these blank records as a 0?

Any help would be greatly appreciated.
Click to expand...

Blank as in Null?
The field is a number datatype?
Set the Format Property of the control to:

#,###.00;-#,###.00;.00;.00

Values of 0 or Null will display as .00
Other values will display with 2 decimals.

To learn why this works, look up
Format Property + Number and Currency datatypes
in Access help.
 
Back
Top