I have a main report with several subreports. Sometimes the subreports will
not have data to display for that particular main report and I'd like to
hide the subreport. Actually I'd like to hide and shrink the subreport so
there won't be a blank area in the main report. Any ideas?
I've tried to make the subreport not visible if there is no data but the
blank area is still there.
>I have a main report with several subreports. Sometimes the subreports will
>not have data to display for that particular main report and I'd like to
[quoted text clipped - 3 lines]
>I've tried to make the subreport not visible if there is no data but the
>blank area is still there.
Subreport's with no data are automatically blank, so all you
have to do is make sure the subreport control's and its
section's CanShrink property are both set to Yes.

Signature
Marsh
MVP [MS Access]
Karen - 30 Oct 2004 22:39 GMT
Marsh,
Thanks very much.

Signature
Karen
>
>>I have a main report with several subreports. Sometimes the subreports
[quoted text clipped - 9 lines]
> have to do is make sure the subreport control's and its
> section's CanShrink property are both set to Yes.