How do I force a 0.00

[BobC]

Using Access 2000
How do I force the output to print 0.00 when the numbers add to 0
Right now the field shows a blank when the numbers add to 0
I have the Format property set to 'Standard' such that other numbers
come out like 9,322.47

 

[Fredg]

Set the Control's Format property to:
#,###.00;-#,###.00;0.00

If you also want something to print if the control is empty (Null), use:
#,###.00;-#,###.00;0.00;"N/A"

See Access Help files regarding the Formatting of Number and Currency
datatypes.

 

[Fredg]

Fredg,
Thank you!
Actually, I did try to look it up in the help files, but could not seem
to find what I was looking for ... so I posted this to get me started in
the right direction.
Thanks again ...
Bob

Bob,
When you need information about any property, place your cursor in that
property line and press F1. The help window for that property will open.

Placing the cursor on the format property line of a control, and
pressing F1, opens the Help file at the Format property help sheet.
Clicking on Numbers and Currency Data Type link opens the file to that
section.