Suppress Zero

G

Guest

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

Guest

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

suppress same information for the row 1
2 related questions 5
Suppress Zero values on the report 3
Suppress Blank Subreports 2
Supressing a Zero Value Field 3
Suppressing Page Header for Specific Page 3
Hiding 0 Values In Reports 13
Suppress if blank 17

Top