Stop blank pages printing

[Access Virgin]

I have a report that contains 9 subreports. Each subreport returns records for a particular sections. Each section starts on a new page, so there will be a minimum of 9 pages each time the report is run. This works fine but when a sections has no records to return there is a blank page printed out with the other pages of the report. It is easy to remove the page but if more than one section returns no records then there will be more blank pages.

I want to set the report up so that if a subreport is blank that it doesnt print out a blank page(s). Any suggestions???

 

[Rich]

Set the CanShrink property to Yes

 

[Access Virgin]

on all the subreports or the main report????

 

[Rich]

Main report

 

[Access Virgin]

doesnt work