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...
 
Back
Top