Suppress Text on a Report

[clk]

I am working on a report in a database. This system was created by
someone else. They had an on print event in the detail section of the
report to suppress text in that area if the field is an "FT" or a
"PT". If it is an "X" they want it to print otherwise leave it
blank. The fields on the report are based on combo box value
fields.

I have tried an IIF statement in the underlying query but that is
limiting the records. I have tried variations of code to limit it on
the print event. Nothing seems to be working.

Any help would be appreciated.

 

[Marshall Barton]

I am working on a report in a database. This system was created by
someone else. They had an on print event in the detail section of the
report to suppress text in that area if the field is an "FT" or a
"PT". If it is an "X" they want it to print otherwise leave it
blank. The fields on the report are based on combo box value
fields.

I have tried an IIF statement in the underlying query but that is
limiting the records. I have tried variations of code to limit it on
the print event. Nothing seems to be working.

Generally the visibility of controls needs to be set in the
section's Format event instead of the Print event.

If there are other problems, then post a Copy/Paste of the
code.