report sometimes prints final blank page (except for page header)

J

John S. Ford, MD

I'm coding in Acc97 and Acc2000 and have a report that lists a set of
patients with various fields including several subreports in list view whose
CanGrow is set to yes. So each record can have varying heights on the page
and a given page will contain varying numbers of records. Each new page
also has a page heading and a footer that lists "Page X of Y".

The report works perfectly except for one thing. Sometimes after it prints
all the patients, it prints one additional page that's blank except for the
page header. That wouldn't ordinarily be a problem as I can simply not
distribute the last page to people needing the report. The problem is that
the "Page X of Y" in the footer will be inaccurate (giving the impression
that a page is missing from the report).

Why is my report sometimes printing that last blank page (blank except for
the page header) and is there any way to prevent it?

John
 
P

Peter R. Fletcher

This can be extremely difficult to avoid completely. Access is very
literal-minded, and will print a new page if any part of the last data
section (usually a detail line or Section footer, but not counting
Page footers), _including_ _trailing_ _blank_ _space_. goes over the
end of the page. Look at your Report format and try to get rid of any
trailing blank space in any section that is or may be the last "real"
section in the Report to be printed. One often puts in trailing blank
space for aesthetic reasons in spacing repeating sections, and it can
be quite tricky to replace it with leading blank space in the same or
other sections while retaining the same aesthetic effect, which is
what one needs to do.


I'm coding in Acc97 and Acc2000 and have a report that lists a set of
patients with various fields including several subreports in list view whose
CanGrow is set to yes. So each record can have varying heights on the page
and a given page will contain varying numbers of records. Each new page
also has a page heading and a footer that lists "Page X of Y".

The report works perfectly except for one thing. Sometimes after it prints
all the patients, it prints one additional page that's blank except for the
page header. That wouldn't ordinarily be a problem as I can simply not
distribute the last page to people needing the report. The problem is that
the "Page X of Y" in the footer will be inaccurate (giving the impression
that a page is missing from the report).

Why is my report sometimes printing that last blank page (blank except for
the page header) and is there any way to prevent it?

John


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
J

John S. Ford, MD

Well I found one solution that seems to work: I set the report footer
section height to 0" (the default seems to be 0.25"). This seems to have
solved this problem for me.

John
 
P

Peter R. Fletcher

If there wasn't anything (Controls or Text) in the Report Footer
section, the original setting would be equivalent to adding 0.25" of
blank space on to the bottom of the printed text on the last "real"
page of the Report - this could certainly have given you the symptoms
you were seeing.

Well I found one solution that seems to work: I set the report footer
section height to 0" (the default seems to be 0.25"). This seems to have
solved this problem for me.

John


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top