Suppress Zero

N

NevilleT

Probably a very simple answer to this but I can't find it. How do I suppress
zero (display as a blank) on a report.
 
F

fredg

Probably a very simple answer to this but I can't find it. How do I suppress
zero (display as a blank) on a report.
Click to expand...

Set the Format property of the control to:
#;-#;

Look up the Format property + Number and Currency datatype in Access
help.
 
N

NevilleT

Thanks Fred. That did the trick.

fredg said:
Set the Format property of the control to:
#;-#;

Look up the Format property + Number and Currency datatype in Access
help.
Click to expand...
 

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

Similar Threads

Can't seem to delete all images from a Word Doc 2
Zero Suppress 1
How to correct a #N/A in vlookup 1
Mail Merge Switch - Dollars to Words 0
How to display zero value in blank fields of Cross Tab query 0
suppress same information for the row 1
Cumulative formula for word table 0
Uninstall and install Publisher 365 0

Top