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
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Without a sample, I cant be sure...

Just as a sanity check, make sure the "Force New Page" property of the detail section is set to: None
Dale FyeConnect With a Mentor Commented:
First thinks I would check:

1.  Check to make sure the page width and margins are set properly.  If your report is too side and the margins are set wrong, it can force a blank page.

2.  Check to see whether you have a group footer that forces a new page

3.  Make sure there are no Page Break controls embedded in the report
Jeffrey CoachmanMIS LiasonCommented:
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?
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to and use offer code ‘EXPERTS’ to get 10% off your first purchase.

VirtualKansasAuthor Commented:
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.)
VirtualKansasAuthor Commented:
Big report, so yes in print preview and yes to .pdf option (blank sheet appears in both after every record.)
VirtualKansasAuthor Commented:
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.)
VirtualKansasAuthor Commented:
Force New Page is set to NONE
Dale FyeCommented:
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
VirtualKansasAuthor Commented:
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 FyeCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.