Forcing 0.00 when the sum is zero

  • Thread starter Thread starter BobC
  • Start date Start date
B

BobC

Using Access 2000
The problem concerns reports.
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
 
Set the Format Property of the TextBox to "#,##0.00".

Check Access Help topic "Format Property - Number and Currency Data Types"
for more options.
 
Back
Top