I've created a main report with about 10 sub reports. My problem is that the sub reports are not shrinking all the way. They go most of the way and then create a small space. Normally, this wouldn't be terrible, but with 9 stacked reports it creates a rather large space at the top of the final report.

I've set the properties to "Shrink" and entered the following event on "No Data".


Private Sub Report_NoData(Cancel As Integer)


Cancel = True
End Sub

Is there any way to remove the extra space so that the final report compresses completely?

I've posted the DB in case you need it (I haven't split it yet so there's only one file). It should Open the form: frmLbl

The main report pulls the active Item #. Use the Previous and Next buttons to go to a different Item #.

Open report: rpt1 and go to Print Preview (you can't just open the report because the formatting will be all goofy, it must be in print preview)

DSLbl9.zip