Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access printing extra page in reports

Posted on 1998-12-22
4
Medium Priority
?
283 Views
Last Modified: 2008-03-17
Can you please tell me why access prints an extra page when either printing or previewing a report.

thanks
0
Comment
Question by:spatel121798
  • 2
4 Comments
 
LVL 7

Expert Comment

by:Victor Spiridonov
ID: 1971829
Check if you have 'Force new page' setting turned on for report footer.
0
 
LVL 10

Accepted Solution

by:
brewdog earned 0 total points
ID: 1971830
I would bet that one of your controls in one of the sections is just a little bit too wide for the section. Try one of these two things:

1. Shrink the margins a little bit
2. Stretch the right edge of the report in design view a quarter inch or so to the right.

See if one of those takes care of it. (If you don't have room to stretch the report or change the margins, then put your mouse in the ruler across the top of the screen on the far right edge of the report and click. See what gets highlighted -- it's probably a line/border that's a little too wide.

Hope that helps.

brewdog
0
 

Author Comment

by:spatel121798
ID: 1971831
Your answer was spot on brewdog, thanks again.
0
 

Author Comment

by:spatel121798
ID: 1971832
cheers, youre a superstar brewdog  - it worked!!!

Thanks.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

810 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