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;""
 
Back
Top