Avatar of VirtualKansas
VirtualKansas asked on

Access report printing producing blank page after each record

Small potato but a nuisance.  A report from an old database prints normally.  New version based on old database now produces same report with a blank page between records?

Quick way to review and resolve?  TY
Microsoft Access

Avatar of undefined
Last Comment
Dale Fye

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Dale Fye

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jeffrey Coachman

I think fyed may have your answer here...
Even though it may not be obvious, a lot of things change in the way the report is rendered in different versions of Access.

If you margins were already "right on the edge", a small change in the rendering may force a new page...

Does the new page appear in Print Preview as well as the actual hard-copy printout?
ASKER
VirtualKansas

Piddly problem, but still...

Screen shot of current settings.  Can't find the "Force New Page" property.

Access reports the error on the form as "Report width is greater than page width", but width is only 10" and error solutions are defiant (no working.)
report-size.jpg
ASKER
VirtualKansas

Big report, so yes in print preview and yes to .pdf option (blank sheet appears in both after every record.)
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
VirtualKansas

Batsh*t (apologies.)  There is a "cousin" report with width of 9.5417" and the bigger version has a width of 10", but won;t let me change it down to the 9.5417"?

Pesky, all the effort to get this far and users won't care until reports look right (life in big city.)
ASKER
VirtualKansas

Force New Page is set to NONE
Dale Fye

If you are getting the "Report width is greater than page width" message, you definately need to change the orientation (portrait to landscape) of your report, or change the margins.  A standard 8 1/2" x 11" will normally have margins of .5" to 1".

1.  Open your report in design view.  
2.  Click the "Page Setup" tab in the ribbon
3.  click the "Landscape" button on the page setup tab
4.  click the Page Setup icon on the Page Setup tab.  Adjust your left and right margins so that the report will fit on whatever size paper you are using.  If the report is 10" wide, I would set my left margin to .5" and the right to .25"report page setup
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
VirtualKansas

Split points with tilt to  boag2000 for speed in reply; thank you, I'm thick headed from the real effort and didn't notice a control was extending out to the 10" page width.

Skinny'ed up the control, got the width down to  same as cousin report.  All good...
Dale Fye

but won;t let me change it down to the 9.5417"

This is generally because you have a line that is hard to find, a label that extends across the entire top of the page, or maybe even a "page X of Y" label in the bottom right corner of the report.