Having a strange thing that I've never run into before. I have a report with
a zero-height group footer section which is set to force new page after
section, so that each item in the group begins at the top of its own page.
For some reason, when it gets to the end of the last group item, it still
forces a new page, resulting in a single blank page at the end of the
report.

I've been creating reports like this for years, and I've never had this
problem. Access never forced a new page after the last group in the report.
But I'm doing this in Access 2010, and something tells me that this is one
of the bugs in that version.

Anyway, was wondering if anyone else has run across this problem, and if
there are any known workarounds.

Thanks!

"Neil" <neil.ginsberg+newsgroup (AT) gmail (DOT) com> wrote

property. I Deleted the empty report footer to eliminated the extra page. It
looks like Access 2010 looks at the report footer differently from previous
versions.

"ron paii" <none (AT) nospam (DOT) com> wrote

they ever come out with it, that is!!

So what did you do as a workaround when you removed the footer?

"ron paii" <none (AT) nospam (DOT) com> wrote

Interesting note: the database is an MDB file, and when I open it in 2003,
the report works fine - no blank page at the end. Clearly a glitch in 2010.

"Neil" <neil.ginsberg+newsgroup (AT) gmail (DOT) com> wrote

"Force New Page after Section" was on the footer of a group section.

"ron paii" <none (AT) nospam (DOT) com> wrote

Yes, that's what I have - Force New Page After Section in the footer of a
group section, where the footer is empty. But I use that start a new page
with each group item. Otherwise, if you do a page break before the header
section of the group, then the first group ends up on page 2. So by putting
a Force New Page After Section in the empty footer section of the group, it
starts the next group on a new page.

So what I'm saying is, how did you get each group item to start on their own
page if you didn't do it with the footer section?

Thx

"Neil" <neil.ginsberg+newsgroup (AT) gmail (DOT) com> wrote

footer will print on a new page after the group footer. If the Report footer
is empty, delete it.

"ron paii" <none (AT) nospam (DOT) com> wrote

Ah, I see what you're saying. I thought it was the group footer that was
showing up on the last page. But both the group footer and report footer are
zero-height, so it could be either. What you say makes sense.

Unfortunatately, though the report footer is empty, I can't delete it. I'm
using the report header, and the two go together. So I guess I'm stuck.

Interesting thing, though: I tested it in A2007, and no problem. It's only
in A2010. Hopefully this is something they're going to fix soon.

Thanks.

Neil,
Even though you cannot delete the report footer section (because you
need the report header section), you CAN change the "Force New Page"
property to NO inside the report footer section.

You only need the "Force New Page" setting in the group footer
section.

Fred


On May 9, 3:11*pm, "Neil" <neil.ginsberg+newsgr... (AT) gmail (DOT) com> wrote:

<zuckermanf (AT) gmail (DOT) com> wrote

Neil,
Even though you cannot delete the report footer section (because you
need the report header section), you CAN change the "Force New Page"
property to NO inside the report footer section.

You only need the "Force New Page" setting in the group footer
section.

Fred

==============

Yes, that's right. I don't know if you read this thread, but that's not the
issue. The issue is that a glitch in Access 2010 (but not previous versions)
causes a blank page to appear at the end of a report that has a report
footer, which has the GROUP footer set to Force New Page. Apparently,
deleting the report footer resolves the problem. But the report footer never
had Force New Page in the first place, only the group footer. But this is a
bug in Access 2010.