Results 1 to 4 of 4
  1. #1
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155

    Regarding Reports

    I have made a report containing 2 subreports. The report appears tidy in the Report View. But in Print Preview there appear many blank spaces and blank pages.Hoaw can I avoid these?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in each sub report, tighten up the page,
    narrow the paper width and length borders,
    turn on : can shrink

    cant say anymore without seeing it.

  3. #3
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155
    Quote Originally Posted by ranman256 View Post
    in each sub report, tighten up the page,
    narrow the paper width and length borders,
    turn on : can shrink

    cant say anymore without seeing it.

    The spaces caused in the Print Preview are due to the Report extending beyond the page limits. Is there any option in the Design or Layout View which can shrink the Report and bring it within the page limits thus eliminating the spaces.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Design view is used to move items manually.
    As Ranman has already said,
    1. You will need to move controls up or to the left to make them fit removing any unnecessary 'white space'
    2. You can also reduce the page margins to fit more on the page
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 02-08-2017, 04:11 PM
  2. Convert Client Reports to Web Reports
    By need_help12 in forum Reports
    Replies: 0
    Last Post: 05-08-2012, 08:22 AM
  3. Reports
    By brobb56 in forum Access
    Replies: 5
    Last Post: 09-21-2011, 02:09 PM
  4. Reports w/ sub-reports very slow to open
    By vaikz in forum Reports
    Replies: 2
    Last Post: 02-27-2011, 08:41 AM
  5. Access Reports drop sub-reports
    By Kevin Ellis in forum Reports
    Replies: 0
    Last Post: 11-19-2010, 03:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums