how do i hide fields (controls) on a report

[Karen]

I am writing an app in Access 2002 and need to print a certificate of
compliance report. In the table that the report is based on, there are 15
test fields (fldtest1, fldtest2, ..., fldtest15). There are also results
fields and then there are specification fields. The report prints the
fields even if they are blank (null) or zero. I would like those blank or
zero fields not to print on my report. How do I do that?

Karen

 

[Guest]

Try using the above recommendation for the IIF Visible statement.

Or else,
You can use the CanGrow property of your text field and shrink it down to a
line. I do not know how that will look on your report but if you have data
on the same line as a CanGrow field, it can get out of line. You can also
change your format of a number to be blank for zeros. Put the format at
#,###.00;-#,###.00;""

Hope this helps.