zero suppression in a report 1

[BitZero]

How can I zero suppress a number on an Access Report?

I've tried the following, but nothing works.

- change the input mask property to ###.##
- change the input mask property to 000.00
- change the format property to ###.##;###.##;;
- change the format property to fixed and decimal places to 2.

Thanks

 

[dhookom]

If you mean you want to not display zeros, then try:[tt][blue]
- change the format property to ###.##;###.##;"";[/blue][/tt]

Duane
Hook'D on Access
MS Access MVP

 

[BitZero]

That worked! Thanks