Suppress Subreport

[Yvaine]

I have three subreports in my main report's footer. However, when there are no records at all in these subreports, it takes spaces of main report. How can i suppress where there is no record?

[OBP]

You can supress the subreport by making it invisible, but it is very difficult to "get back" the "Space" where the sub report goes, you literally have to redimension the sub report.
To hide it you can use this
Me!SubReportControl.Visible = Me!SubReportControl.Report.HasData
see the VBA Help (not Access help, they are different) to search for the "HasData" method.

[slurpee55]

OBP, while it isn't perfect, doesn't setting the property value of Can Shrink = Yes help with this?