John,

I cannot locate where I would use the HasData property of the sub-report. I
am aware of the can shrink property and have that set to yes (also have the
can grow property set to yes). I have looked at each line in the properties
window but cannot locate where I set the HasData property. In fact I typed in
HasData into the help menu and there were no results found. Could you please
give me a little more assistance?
--
Bruce


"John Spencer" wrote:

You can use the HasData property of the sub-reports to control the visibility
of the sub-report control. In addition, you can set the can shrink property
of the section containing the sub-report control(s) to yes to recover the space.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Allen Browne wrote:
Part 1:
If the main report is bound to a table/query, you can just cancel its
NoData event.

If the main report is unbound (merely a holder for the 3 subreports),
you would need to write some code in the Open event of the report to
DLookup() the 3 source queries for the 3 subreports to see if you get
anything. If you don't, then cancel Report_Open.

Part 2:
Set the CanShrink property to Yes for the subreport control, and also
for the section that holds the subreport.

Provided there is nothing else overlapping the subreport's vertical
space, it will then shrink if it has no data.

.