Supress zero values in a report 1

[Mack2]

Much of my data in a report are of the value zero. How do I supress a value if it is zero. I would just like the value to be blank. THANKS IN ADVANCE!

 

[RoyVidar]

One of the easiest ways, I think, is to use the format property of the control, which can take four arguements (format if positive, negative, zero and Null) - so for instance something like this

[tt]# ##0.00;[red]-# ##0.00;"";""[/tt]



Roy-Vidar

 

[Mack2]

It worked! THANK YOU!!!!!!!!!!!!!!!!!!!!!!