When I open a particular form I created in print preview mode I receive a message that reads "The Section Width is Greater Than the Page Width, and there are no items in the additional space so some pages may be blank" And when I go to print the form blank pages do in fact print out. Can someone please tell me how I can decrease the section width, and stop having the blank pages print? Thank you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SECTION WIDTH 1
- Thread starter wcj00
- Start date
-
1
- #2
TonyJollans
Programmer
Hi wcj00,
Before printing, Access looks at -
(a) the position of the end of the rightmost control and
(b) the width of the report
- and compares the two to the information it has about the printer.
If all the controls will fit within the width of a single page but the width of the report is wider than the page width, it issues the message you get.
It means you have some space on the right of the rightmost control. To get rid of the message you must make the report narrower so that there is no longer blank space within your report beyond the page width. You may as well bring the right edge in to the right edge of the rightmost control.
To do this - in Report Design View -
- If the Properties box isn't visible Select Properties from the View Menu
- Make sure the Report (and not an individual Control or Section) is selected - click on any dark grey area outside the report area but inside the design window, or on the small grey square in the top left of the design window
- Click on the Format Tab in the Properties box
- Change the width to 0 (zero)
- Press ENTER and Access will change it to the narrowest it can be to contain all the controls
Hopefully that will have done the trick and your message will go away.
Enjoy,
Tony
Before printing, Access looks at -
(a) the position of the end of the rightmost control and
(b) the width of the report
- and compares the two to the information it has about the printer.
If all the controls will fit within the width of a single page but the width of the report is wider than the page width, it issues the message you get.
It means you have some space on the right of the rightmost control. To get rid of the message you must make the report narrower so that there is no longer blank space within your report beyond the page width. You may as well bring the right edge in to the right edge of the rightmost control.
To do this - in Report Design View -
- If the Properties box isn't visible Select Properties from the View Menu
- Make sure the Report (and not an individual Control or Section) is selected - click on any dark grey area outside the report area but inside the design window, or on the small grey square in the top left of the design window
- Click on the Format Tab in the Properties box
- Change the width to 0 (zero)
- Press ENTER and Access will change it to the narrowest it can be to contain all the controls
Hopefully that will have done the trick and your message will go away.
Enjoy,
Tony
I'm having the same problem. The report was originally designed landscape, but I've removed many columns and it now fits into portrait. The report grid continues to be out at 9". I drag it to 7.5 and it snaps back to 9. There are no controls even close to 7". I have tried changing width to 0 and it goes back to 9". Any other ideas?
TonyJollans
Programmer
Hi rptnut,
If it keeps snapping back to 9", it is almost certainly because you have some sort of control extending out to 9". It may be a line (perhaps at the bottom of a header or the top of a footer) which can be hard to see. Try selecting all the controls (Edit > Select All, or press <Ctrl><A>) - the handles can sometimes make it easier to see what you have got.
Enjoy,
Tony
--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
If it keeps snapping back to 9", it is almost certainly because you have some sort of control extending out to 9". It may be a line (perhaps at the bottom of a header or the top of a footer) which can be hard to see. Try selecting all the controls (Edit > Select All, or press <Ctrl><A>) - the handles can sometimes make it easier to see what you have got.
Enjoy,
Tony
--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Thanks Tony,
I believe I've got all those. If I change the background color in the detail section, I can see that color on the second (erroneous) page. I have tried to change the width of the detail section section to no avail.
I'll try your suggestion when I get back at it tonight.
Thanks,
Nolan
I believe I've got all those. If I change the background color in the detail section, I can see that color on the second (erroneous) page. I have tried to change the width of the detail section section to no avail.
I'll try your suggestion when I get back at it tonight.
Thanks,
Nolan
- Status
Similar threads
- Locked
- Question