How do i remove zeros on the printed report

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

Guest

I trying to remove zeros from a report when printing. The zero is a number
that is not always required in the database.
 
Without more details, it will be very hard to answer your question. If you
want to prevent the entire record with a value of "0" from being pulled to
the report, then modify the query that pulls the records to the report to
only pull records where the value is greater than zero.

To change how it prints, you might look at the "format" of the control.

You might also want to replace the field in your report with an unbound
control and include an IF statement to print the value only if it meets your
criteria.
 
I trying to remove zeros from a report when printing. The zero is a number
that is not always required in the database.
Click to expand...

Several ways.
Easiest is to set the format property of the control (in the report)
to:
#;-#;""

look up Format property + Number and Currency datatypes
in Access help.
 
Back
Top