extra white space in print preview of access report?

[Pmo2014]

Hello,

I created a report in MS Access 2013. Everything functions fine, until I try to view the report in Print Preview. I get a bunch of white space below the details section. My report is designed to fit on one page (landscape). I've made sure all "Can Grow," and "Can Shrink" properties are enabled for each section. I've tried color-coding each section and re-running the report, only to find that I get empty white space beneath the detail view (approximately 1/4 of a page worth)-the color coding was used to determine what section was expanding, but the space still showed white. This space fluctuates with the amount of data in the report. When it is full of data, everything looks fine, when only a few records are returned by the query, I get a bunch of white space. Any ideas. I've searched around for days now, and can't figure it out. I should also mention that I have two subreports in the footer section of the main report. The section above these two subreports and below the details section of the main report is what shows white space. Thank you in advance!

[jimatqsi]

The image quality is too poor for me to make out the important details.

I'd start by making a copy of the report and then tinker with the copy. Remove either/both of the sub-reports and try it. Put borders around or shading in various objects to verify where they begin and end. Play and learn.

Jim

Jim

[mcupito]

In the SubReports, in the "On No Data" event, did you try

Cancel = True

That way, subreports aren't taking up space on your report if they contain nothing.

Also, double and triple check all of the report areas/subreport areas have "Can Grow" and "Can Shrink" set to "Yes". I know you said they do, but even in your subreport you should make sure.

Also, in the ReportViewOfReport.jpg, what do you want the report to look like? Nothing looks 'off' to me. Part of the detail section is extending the lower limit because of the subreport on the left (if that is a subreport). The subreport on the right has no control over that.