Do not print zeros

  • Thread starter Thread starter GB
  • Start date Start date
G

GB

This is probably really easy but I can't find out how to do it!!

On my Invoice report I don't want to print the field if it is zero, for
example I have options on the orders, i.e. number of holes, size of holes,
etc.

Where these are zero I don't to print them. At the moment my Invoice has
loads of zeros where these options have not been taken up on the order!

Any ideas?
 
To suppress the zero, set the Format property of the text boxes on your
invoice.

The 3rd part of the Format property indicates what to print for zero, so use
something like this:
#,##0;-#,##0;""
 
Works fine - Thank you!

Allen Browne said:
To suppress the zero, set the Format property of the text boxes on your
invoice.

The 3rd part of the Format property indicates what to print for zero, so use
something like this:
#,##0;-#,##0;""
Click to expand...
 
You must log in or register to reply here.

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 Upload Speed 6
Access Reports: leave blank instead of printing zeros 2
How to print dash ("-") for zero values 2
page header on second page of invoice. 3
Assigning print date / batch number to reports & invoices 6
Printing invoices 3
Suppress a section if the subtotals equals zero 1
Printing of sub-report skips to second page. 3

Back
Top