Hide Multiple Controls

[Rhonda Floyd]

In a report, is there a way to Hide multiple controls that are Zero?

I have over 100 fields on a report that could be 0 that I would like to show as blank when 0 otherwise print the number.

I'm using Access 97.

Any help will be greatly appreciated.

Thank you,
Rhonda

 

[Marshall Barton]

In a report, is there a way to Hide multiple controls that are Zero?

I have over 100 fields on a report that could be 0 that I would like to show as blank when 0 otherwise print the number.

I'm using Access 97.

The simplest approach is to set the text box's Format
property to a custom format. E.g. for currency values, it
might be:
$#,##0.00;($#,##0.00);"";""

Check Format Property in Help for details.

 

[Kelvin Lu]

Try

=IIF([FieldToCheck]=0,"",[FieldToCheck])

for the textbox in the report. If the report is based on a query, I would set this in the query.

Kelvin
In a report, is there a way to Hide multiple controls that are Zero?

I have over 100 fields on a report that could be 0 that I would like to show as blank when 0 otherwise print the number.

I'm using Access 97.

Any help will be greatly appreciated.

Thank you,
Rhonda