How to set a field to blank when it's displaying 0.00

[ridgelon]

I'm writing a report that shows several rows whose values are 0.00 when not used. Trying to hide them unless they are used. I know you can set Format to #;-# and show nothing if the field is set to 0, but if it's 0.00 it will still show .00 I need the two decimal places, so setting Decimal Place to Auto is not an option.

How can you get rid of the decimals?

[Stewart Ross]

Change the Decimal Places value back to Auto. Use the Format property of the textbox concerned instead.

You can then define a custom display format in the sequence

(positive values format); (negative values format); (zero values format); (null values format)

All you need to display non-zero values to two decimal places but zeroes as blank is to set the Format property of the textbox to:

0.00; -0.00;

Please note that if you leave the decimal places property set to 2 it will override this custom format, so please change it back to auto accordingly before you make the format change.

-Stewart