Last Report Page Blank - 2010
Neil
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!
ron paii
"Neil" <neil.ginsbe...@gmail.com> wrote in message
news:iq8l95$oee$1...@dont-email.me...
Had the same problem; if a section had "Force New Page after Section"
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.
Neil
"ron paii" <no...@nospam.com> wrote in message
news:iq8o4j$ee4$1...@dont-email.me...
they ever come out with it, that is!!
So what did you do as a workaround when you removed the footer?
Neil
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.
ron paii
"Neil" <neil.ginsbe...@gmail.com> wrote in message
news:iq8pn1$7id$1...@dont-email.me...
I didn't need it, the footer was empty.
"Force New Page after Section" was on the footer of a group section.
Neil
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
ron paii
"Neil" <neil.ginsbe...@gmail.com> wrote in message
news:iq8vh2$22u$1...@dont-email.me...
I also put the Force new page in the group footer. The problem is the REPORT
footer will print on a new page after the group footer. If the Report footer
is empty, delete it.
Neil
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.
zucke...@gmail.com
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...@gmail.com> wrote:
> "ron paii" <n...@nospam.com> wrote in message
>
> news:iq99ac$ds4$1...@dont-email.me...
>
>
>
>
>
>
>
> > "Neil" <neil.ginsberg+newsgr...@gmail.com> wrote in message
> >news:iq8vh2$22u$1...@dont-email.me...
>
> >> "ron paii" <n...@nospam.com> wrote in message
> >>news:iq8ulb$604$1...@dont-email.me...
>
> >>> "Neil" <neil.ginsberg+newsgr...@gmail.com> wrote in message
> >>>news:iq8pn1$7id$1...@dont-email.me...
>
> >>>> "ron paii" <n...@nospam.com> wrote in message
> >>>>news:iq8o4j$ee4$1...@dont-email.me...
>
> >>>>> "Neil" <neil.ginsberg+newsgr...@gmail.com> wrote in message
> Thanks.- Hide quoted text -
>
> - Show quoted text -
Neil
<zucke...@gmail.com> wrote in message
news:f1d5bd20-16cc-4402...@b7g2000prg.googlegroups.com...
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.
Phil Hunt
Are you sure it is not a margin issue when the last page is printed,it needs
another page ??
Neil
"Phil Hunt" <a...@aaa.com> wrote in message
news:iqhmgv$q7t$1...@speranza.aioe.org...
> Just a shot in the dark.
>
> Are you sure it is not a margin issue when the last page is printed,it
> needs another page ??
>
Try it yourself if you have 2010. Set a group footer to force a new page,
and include a report footer. See what happens.
