Forcing 0.00 when the sum is zero

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
 
V

Van T. Dinh

Set the Format Property of the TextBox to "#,##0.00".

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

BobC

I had tried to look it up ... guess I did not ask HELP the right question.
Thanks! ...
 

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

Top