Possible to have section of report not print based on content in table

[ghadley_00]

Hi,

I have a report that has a section that has a combination of text
labels / lines and table fields in one of its sections. If the table
fields for this section are blank I would like to have that entire
section of the report not print. Is there a way to do this? I realize
that shrink / grow could be appliable, but is there a way to make the
lines also disappear?

Best wishes,

George Hadley
(e-mail address removed)

 

[Allen Browne]

Create a query that uses criteria to exclude these records.
Use the query as the RecordSource of the report.
The whole problem is then solved.

In the criteria row of your query, under the appropriate fields, you will
need to use:
Is Null

 

[Klatuu]

You can put code in the Format event of the section you want to hide that
will determine wether you want it visible or not and set the section's
visible property to the desired value.