Results 1 to 3 of 3
  1. #1
    degras is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    72

    Page with no data / content at end of report

    I have a report which has a page break at the end of every record and a page break at the end of every group. This works nicely except at the end of the report there is a page with header and footer but no content / data (so essentially its blank if you ignore the header and footer.) Any idea as to how I might fix this annoyance and potential waste of paper?

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    almost more an art than a science on things like this.....I think it might be your blank white space in your detail area (areas between headers) that needs to be tweaked smaller so as to not trigger the next page.....

  3. #3
    degras is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    72
    I reduced the vertical space at the end of the detail section and at the end of the group footer. I reduced the width of the report in the design view to 19cm, none of the controls goes over this width. Still there is a page with no data, just the header and footer at the end of the report. Is the report narrow enough? I don't know what else to do to get rid of this space.

    ... Update: in the end I got rid of the page breaks from the detail and group footer sections and this solved the problem.
    Last edited by degras; 02-17-2011 at 07:11 AM.

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

Similar Threads

  1. Add Page to undound report
    By Gary in forum Reports
    Replies: 1
    Last Post: 07-14-2010, 05:43 AM
  2. Page break on report inserts empty page between
    By Galadrielle in forum Reports
    Replies: 0
    Last Post: 07-07-2010, 04:18 AM
  3. Replies: 1
    Last Post: 05-22-2010, 08:30 PM
  4. Emailing report at the Email content
    By ylivne in forum Reports
    Replies: 0
    Last Post: 07-07-2009, 05:31 AM
  5. report prints blank page at end of report
    By darrellx in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 08:51 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