Number formatting...

[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.

 

[fredg]

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.

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.