extra blan page

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I have a report and set footer force new page after section.

The report always has one extra blank page at the end, since force new
page after section.

Are there any way to eliminate the extra blank page at the end of
report when the report force new page after footer section set?



Your information is great appreciated,
 
iccsi wrote:
I have a report and set footer force new page after section.
The report always has one extra blank page at the end, since force new
page after section.

Are there any way to eliminate the extra blank page at the end of
report when the report force new page after footer section set?
Click to expand...


Which footer?
What other sections does the report have?

In most(?) cases, you can set some(?) section's ForceNewPage
to Before Section.
 
iccsi wrote:

I have a report and set footer force new page after section.





Which footer?
What other sections does the report have?

In most(?) cases, you can set some(?) section's ForceNewPage
to Before Section.
Click to expand...

It is group footer.
If I set before section on the group header then there will be empty
page in the begining of the report.

Thanks again,
 
iccsi said:
It is group footer.
If I set before section on the group header then there will be empty
page in the begining of the report.
Click to expand...


No, Access does not generate an **empty** page at the start
of a report. You may get a new page after the report header
or a higher level group header. If you have no higher level
group headers abd nothing in the report header and still get
a blank page at the start of the report, then set the report
header's Height to 0 or make it invisible.

If all else fails, you'll have to find a place to turn off
the group footer's ForceNewPage **before** the group footer
is formatted, maybe in the last group's header.
 
It is group footer.
If I set before section on the group header then there will be empty
page in the begining of the report.
Click to expand...

No, Access does not generate an **empty** page at the start
of a report.  You may get a new page after the report header
or a higher level group header.  If you have no higher level
group headers abd nothing in the report header and still get
a blank page at the start of the report, then set the report
header's Height to 0 or make it invisible.

If all else fails, you'll have to find a place to turn off
the group footer's ForceNewPage **before** the group footer
is formatted, maybe in the last group's header.

--
Marsh
MVP [MS Access]- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks for helping,
 
Back
Top