Results 1 to 10 of 10
  1. #1
    c.d.power's Avatar
    c.d.power is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Florida
    Posts
    44

    Getting an error: "The section width is greater than the page width"

    I'm getting this error when printing my reports:

    "The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank.

    For example, the report width may be wider than the page width."

    I've checked and double checked and made sure that there are no report items outside of the appropriate margins for an 8.5 x 11 page. Any idea what could be causing the issue?

    Thank you in advance for any help.



    ETA: When viewing my reports in Print Preview or when they are actually printed, everything prints properly on the page, but there is a blank page added on.

    Click image for larger version. 

Name:	Capture1.JPG 
Views:	15 
Size:	208.2 KB 
ID:	38649
    Click image for larger version. 

Name:	Capture2.JPG 
Views:	15 
Size:	162.8 KB 
ID:	38650

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I have read this might be caused by printer having a minimum margin requirement. This would mean Access 'knows' the default printer and gets some info from it. What happens if you resize report width to 10.5? At what width does the error go away?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Have you set the page orientation to landscape?

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    in addition to other comments, this is all reports?
    Automatic margin detection and orientation notwithstanding, when I do the math your coin report shouldn't fit but the 1st - possibly. You're cutting it awfully close, assuming your printer can go to those extremes.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    c.d.power's Avatar
    c.d.power is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Florida
    Posts
    44
    Thank you for all the replies. To answer everyone's questions:

    For June7: It appears to me that the error does not go away no matter what the report width is. I have attached an example of a report with an 8.5 report width that is still receiving the error.

    For davegri: All reports are set to Landscape

    For Micron: All reports that I'm creating are encountering the same issue, no matter what the margins are.

    I did create a brand new report without adding any of the other formatting that I've added for the others, and I didn't have the same issue.

    I've attached more screenshots with different examples that will hopefully clarify the issue better.

    Click image for larger version. 

Name:	Capture1.JPG 
Views:	9 
Size:	248.8 KB 
ID:	38705
    Click image for larger version. 

Name:	Capture5.JPG 
Views:	9 
Size:	82.9 KB 
ID:	38706
    Attached Thumbnails Attached Thumbnails Capture6.JPG   Capture4.JPG   Capture2.JPG  

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I would have to work directly with db to analyze issue. If you want to provide, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    c.d.power's Avatar
    c.d.power is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Florida
    Posts
    44
    If it helps, I've attached a copy of the DB as well.Supply Department Tracker (Regiment).zip

  8. #8
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Click image for larger version. 

Name:	powers.png 
Views:	9 
Size:	58.1 KB 
ID:	38711

    Try above.

  9. #9
    c.d.power's Avatar
    c.d.power is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Florida
    Posts
    44
    Davegri, that did the trick! Thanks for your help with this. Marking thread as "solved" now.

  10. #10
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    1. Page Setup on ribbon

    2. Page Setup button

    3. Columns tab

    4. Width = 10.5

    Error message goes away, no blank page.

    EDIT: I see Dave already answered.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 13
    Last Post: 04-15-2018, 06:24 AM
  2. Replies: 3
    Last Post: 04-10-2015, 02:35 PM
  3. Section Width is greater than page width
    By snowboarder234 in forum Reports
    Replies: 3
    Last Post: 07-31-2013, 09:06 PM
  4. Replies: 2
    Last Post: 04-13-2013, 04:38 PM
  5. The section width is greater than the page width?
    By Gary_Marshall in forum Reports
    Replies: 2
    Last Post: 11-13-2009, 01:54 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