Not printing zero...

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

 

[Allen Browne]

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