Solved

Access 2013 - Reporting Question

Posted on 2016-08-07
10
29 Views
Last Modified: 2016-09-01
I am receiving the message:
"The section width is greater than the page width, and there are no items in the additional space,,,,,,"

My report width is 10.2" and my page size is 11"
It is set in Landscape mode.

What am I missing?
Thanks!
Dennis
0
Comment
Question by:DGWhittaker
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 3

Expert Comment

by:bfuchs
ID: 41746621
make sure you narrow the report section to the last control you have on the right side and this message will disappear.
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points (awarded by participants)
ID: 41746750
You are missing the left/right margins. These add to the report width to get the desired paper width.
Quite often you can adjust the right margin down to little or zero.

/gustav
0
 

Author Comment

by:DGWhittaker
ID: 41747016
Setting the right margin to zero resolved my issue.
Thanks Gustav!
Dennis
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 41747024
You are welcome!

/gustav
0
 
LVL 34

Expert Comment

by:PatHartman
ID: 41747914
Setting the right margin to 0 might make Access happy but not all printers will be happy with that as a setting.  You should reduce the width of the report by dragging the right edge to the left so it abuts the right edge of the right-most control.  If your controls go all the way to the maximum page width, then you should adjust some column sizes to reduce it to make room for a right margin.  Make sure you test thoroughly with ALL your different printer models to ensure you don't have any that require a right margin.  Not all printers can actually print to the right edge of a page.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 3

Expert Comment

by:bfuchs
ID: 41747932
You should reduce the width of the report by dragging the right edge to the left so it abuts the right edge of the right-most control
This is what I meant above, the message was indeed due to this and not because of the margin.
0
 

Author Comment

by:DGWhittaker
ID: 41754274
I thought this was closed days ago.
My bad!
Thanks All!
Dennis
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 41754770
It's up to you to mark the answer and close the question.

/gustav
0
 

Author Comment

by:DGWhittaker
ID: 41754785
Understood:)
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 41779496
Reported to be the solution.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now