Hide Multiple Controls

  • Thread starter Thread starter Rhonda Floyd
  • Start date Start date
R

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
 
Rhonda said:
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.
Click to expand...

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.
 
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
 
Back
Top