How do I make the space created by a subreport disappear?

[Ben]

I ma making a report in Access. The report contains a field 'data elements',
then 'interfaces' then 'source/target'. Each of these fields can have, but
not necessarily, a comment added to it. I need to create one report that
contains each interface and it's possible comments, followed by each data
element contained in that interface and it's comments. The problem is that
when I insert a subreport to do this the space created by that report stays
when it contains no data, making my report 1200 pages. Is there any way to
make this space appear when it contains data?

 

[SA]

Ben:

Size your subreport to about .0007 in height (it will then look like a line
on the report in design mode) and set its Can Grow property to true. That
way, when there's data it will grow and occupy space on the report, if
there's no data then it effectively will not display and won't occupy space
either.

 

[Ben]

fantastic!!!! I have been trying to figure that out for ages. Thank you so
much!!