Suppress Zeros in Report Fields (1 Viewer)

[Solar.Paul]

Hi I've created a report which shows zeros in various columns where there aren't any values to report. I think the report would look better and be easier to read without these zeros. I would like to suppress them and display blanks instead. I'm not sure how to do this. Can anyone help please?

 

[CJ_London]

you can either set the control format property or use conditional formatting - the former is probably quicker

To set the format property for the control use something like this - I know it works for forms, don't see why it shouldn't for reports

#;-#;"";

Alternatively, to use conditional formatting set the ForeColor to the same as the BackColor if the value=0