Results 1 to 3 of 3
  1. #1
    grbrum is offline Novice
    Windows 8 Access 2016
    Join Date
    Jun 2019
    Location
    Oxford MS
    Posts
    1

    My Ms Access report fits the margins but still printing a white page after every record

    Hello, I appreciate the help identifying the problem or pointing me in the right direction.
    Ive searched for a solution about this problem but only found that normally the mistake is that the report doesn't fit within the paper margins. I think this is not the case.

    I am making a new report to print batch tickets for our production but when I print it I have one blank page after every ticket.
    On Design view the report is within the margins.
    Header and footer has zero length and are set to invisible.
    Auto Resize = No; Fit to page = yes

    On layout view, when I click on the report, I get an orange square around the first page and a yellow square around the second page. The squares are about one inch apart from each other. I think this white space is the white page.
    On Report view, when I click on the report, the selection covers the report + the white space I mention above as if it is part of the report. and therefore outside the margin and I guess the reason for the white page after every batch ticket.

    I attached some printscreens

    Thank you for any help.


    Click image for larger version. 

Name:	Access 3.png 
Views:	13 
Size:	65.8 KB 
ID:	38687Click image for larger version. 

Name:	Access 2.png 
Views:	13 
Size:	97.4 KB 
ID:	38688Click image for larger version. 

Name:	Access 1.png 
Views:	13 
Size:	128.4 KB 
ID:	38689


  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    What are the left and right margins set to?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You seem sure the report width + margins does not exceed the width of the area that your printer can cover, so maybe:
    - you inserted a page break
    - you have set Keep With Next property in such a way that records are being divided (no image of report in print preview so just guessing)
    - 1 or more of the bottom controls is expanding onto page 2 yet the control has no visible data (invisible data could be line feeds)
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 1
    Last Post: 10-28-2017, 09:20 AM
  2. Replies: 1
    Last Post: 11-15-2016, 02:14 PM
  3. Replies: 0
    Last Post: 04-15-2016, 08:08 AM
  4. Replies: 1
    Last Post: 03-05-2013, 06:38 PM
  5. Replies: 8
    Last Post: 08-12-2011, 11:55 AM

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