How to suppress zeros in printing

  • Thread starter Thread starter Rick
  • Start date Start date
R

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
 
i maybe wrong, but there is a format property you can set to zzzzz.zz or
something like that.
 
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.
Click to expand...

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