Suppress "0" from printing on a report

[JimP]

One way to do this is to set the format to "#,###.00;-#,###.00;[White]".

Is there a better,or more conventional, way?

 

[vanderghast]

If that is the only information, you can remove the record with a WHERE
clause, but that eliminates the whole record, that is why this is only
applicable if this field is the only information to be printed in the 'row':
WHERE fieldname <> 0


Vanderghast, Access MVP

 

[John Spencer]

Try using the format
#,###.00;-#,###.00;"";""

This assumes you want the record to print, you just don't want to see the
value zero displayed by one control.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[JH]

I take it the field is numeric?

When you say suppress, do you mean you don't want zero to show up at all?
or you just want it to be 0.00 (as it appears you are trying to do with your
formatting).

If you just want to suppress it entirely, you can always change the query
that serves as the report recordsource.

find the field that returns the zero (let's call it FieldA) and change it to:
iif(FieldA=0,"",FieldA) As NewFieldA

if you go this route, you'll have to change the data source for the field on
your report (it used to be FieldA, it now would be NewFieldA).

 

[JimP]

Thank you,

This is a numeric field, and I don't want "0's" to show up on the report in
columns where they appear. This solution will work fine.

Try using the format
#,###.00;-#,###.00;"";""

This assumes you want the record to print, you just don't want to see the
value zero displayed by one control.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

One way to do this is to set the format to "#,###.00;-#,###.00;[White]".

Is there a better,or more conventional, way?