Suppress Zero

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.

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

Look up the Format property + Number and Currency datatype in Access
help.
 
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.
 

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

Back
Top