Blank page printing when I supress Report Footer

[Bob Howard]

I have a report (A2K3) where I sometimes want to suppress the Report Footer.

I've tried code in the Report Footer's format and print events to
"Cancel=True".

I've tried to also set "Me.PrintSection=False" in the print event.

I've also done the same in the print event for the Page Header section when
I recognize that the page to come next is the Report Footer (there's no Page
Footer).

No matter what I try, I get a blank page where I want nothing.

I've googled this and found many hits with others seeming to have a similar
issue. But none of those seem to lead to a conclusion that works.

It's not that I care much about a single sheet of paper. But this
application is widely used and iteratively creates a certain report --- one
for each account --- when it then converts to a PDF that gets emailed to the
account holder. So EVERYONE will be getting a blank page at the end of
their account statement. Not too professional !!

Any clues??

thanks --- bob h

 

[Bob Howard]

I found the problem, but so far I've been unable to figure out how to
correct it.

I have a control for which there's a section header and a section footer.
When there's a change in that control, I print some totals and want to start
the next value on a new page.

If I force the section header to do a "page break before", I get a blank
page at the start of the report. If I force the section footer to do a
"page break after", I get a blank page at the end of the report.

It seems I'm between a rock and a hard place on this one. I'll diddle
withit a bit more, but so far I'm stumped (i.e., feeling stupid) !

bob h