Not printing zero...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report I print....that when there is not a number greater zero....it
prints $0.00. The information it pulls from is from a form. I want to be
able to print the Label...but leave the field blank if 0 or less. I can't
change the form...because the form needs to show the $0.00. I know a little
about Access...but I just need a "simple" quick fix. Please bare with a
newbie....step by step instructions would be appreciated.
 
You can suppress the zero by setting the Format property of the text box on
the report.

The Format property will need something like this:
$#,##0.00;-$#,##0.00;""
 

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

Zero to print on report 2
Errors in Report total fields 19
Hide controls where the value is null 6
Text Box is Zero 1
Printing xxx.xx but not 0.00 in reports 3
Null in detail, but zero in totals 3
Conditional tests in Access Reports 2
Displaying zeros in cells 2

Back
Top