How to suppress zeros in printing

[Rick]

Is there a way to supress printing a field when it is zero? Because I sum
the fields they must at times be zero but I don't want a page full of zeros
interspersed with the other numbers.

Thanks in advance.
...rick

 

[Phil Hunt]

i maybe wrong, but there is a format property you can set to zzzzz.zz or
something like that.

 

[John Vinson]

Is there a way to supress printing a field when it is zero? Because I sum
the fields they must at times be zero but I don't want a page full of zeros
interspersed with the other numbers.

You can use the Format property of a report textbox to display zeros
as blank. The Format property for a number lets you specify four
format strings, separated by semicolons, and applies them to positive,
negative, zero and NULL values respectively. So a format of

#;-#;"";""

would display numbers as themselves (using a minus sign for negative
numbers); zero and NULL would display as an empty string.