extra white space in print preview of access report?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pmo2014
    New Member
    • Apr 2014
    • 1

    extra white space in print preview of access report?

    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!
    [IMGNOTHUMB]http://bytes.com/attachments/attachment/7569d1396585155/designviewofrep ort.jpg[/IMGNOTHUMB]
    [IMGNOTHUMB]http://bytes.com/attachments/attachment/7570d1396585155/printpreviewofr eport.jpg[/IMGNOTHUMB]
    [IMGNOTHUMB]http://bytes.com/attachments/attachment/7571d1396585155/reportviewofrep ort.jpg[/IMGNOTHUMB]
    Attached Files
    Last edited by NeoPa; Apr 6 '14, 01:14 AM. Reason: Made pics viewable in thread.
  • jimatqsi
    Moderator Top Contributor
    • Oct 2006
    • 1288

    #2
    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

    Comment

    • mcupito
      Contributor
      • Aug 2013
      • 294

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

      Code:
      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 ReportViewOfRep ort.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.

      Comment

      Working...