Access Report Printing

[Guest]

I have a report (letter actually) written in access reports. No matter what
I do to margins or page set up, I continually get a blank page inbetween each
sheet of my report.

I have gone as far as removing all fields from my report changing margins to
be wide-open and I still get a report with blank pages in between each "Real"
Page. Can someone possibly point out what may be going on?
Sincerely,
Frustrated in Michigan!

 

[Guest]

I've had this happen and found that a line or object was hidden by the
separation bars on the report form. This happens many times when using the
Wizard because sometimes the lines are not readily visible in format view.

Try moving the separation bars away from the data to see if a line or object
had been hidden by the bar. Re-adjust the object and see if that cured your
problem.

 

[Larry Linson]

I have a report (letter actually) written in access reports. No matter
what
I do to margins or page set up, I continually get a blank page inbetween
each
sheet of my report.

I have gone as far as removing all fields from my report changing margins
to
be wide-open and I still get a report with blank pages in between each
"Real"
Page. Can someone possibly point out what may be going on?

The most common cause of this is that you have some object on the report
that is wider than the report plus margins, so you are getting an extension
of the width of your page but the printer has to print it following.

JCraig's suggestions are good.

You should be able to grab the right-hand side of the report, in Design
View, and drag it left to the right-most control. If there is a Control that
you can't easily see, it may pop bak to the right. If that happens, look for
"obscured objects" (like a line that is jammed up to the Section Heading or
Footing.

Larry Linson
Microsoft Access MVP