Blank page end of report

S

sw

My report keeps showing a blank page at the end. Per help from
Troubleshooting, I checked the Report Footer height and it's 0. Suggestions
appreciated!
 
F

fredg

My report keeps showing a blank page at the end. Per help from
Troubleshooting, I checked the Report Footer height and it's 0. Suggestions
appreciated!
Click to expand...

It may be the Detail section (or a Group footer section if you have
one) that is a tad to tall. What happens if you tighten up one of
those sections.
 
S

sw

I think I understand your suggestion, and it did not correct the problem.
It is only the very last page of the report that is extra and blank. There
aren't any extra blank pages throughout the report. Thanks! sw
 
M

Marshall Barton

sw said:
My report keeps showing a blank page at the end. Per help from
Troubleshooting, I checked the Report Footer height and it's 0. Suggestions
appreciated!
Click to expand...


Check the report footer's ForceNewPage proprety.

Check the previous section's ForceNewPage property.

Try setting the report footer's Visible property to No.
 
R

Rebecca

I'm also having the same problem. I've checked everything that has been
mentioned, and nothing works. I'm using Access 2000 with Windows 2000.
 
M

Marshall Barton

Rebecca said:
I'm also having the same problem. I've checked everything that has been
mentioned, and nothing works. I'm using Access 2000 with Windows 2000.
Click to expand...


There are lots of other ways to specify things that result
in blank pages.

If your report is only one page long, you can get a blank
"last" page just by having the report's design width greater
than the paper size less margins.

Having the report footer visible, but blank may also produce
this effect.

Another is a CanGrow text box that is filled with so many
blanks that it spill over to another page.

You'll just have to track it down. One thing that may
assist is to set each section's BackColor property to a
different color so you can see which section(s?) are on the
blank page.
 
B

Bob Howard

To me, the most common issue is something in the report wider than the width
of the paper. This is likely a control without any data (so the page
appears blank).... I think this was previously suggested.

It may also be a margin issue.
 
Top