BLANK PAGE AT END OF REPORT

[news.microsoft.com]

I have a report that has a page break set in the footer of a group.
When it gets to the last item in the group a blank page appears at the end
of the report - I assume because of the page break control.

How can I stop this blank page from appearing?

 

[Fons Ponsioen]

The page break in the footer was probably done to start
each group on a new page.
The way to change that is to remove that page break and
instead in the group header set the property "Force New
Page" to "Before Section".
That should make things work just right.
Hope this helps.
Fons

 

[Newbie]

Thanks but if I do that then I get a blank page on the first page.

How can I get around this?

 

[Fons Ponsioen]

You must have something peculiar in there. Make sure that
you remove any pagebreaks that you inserted in the
report. Placing the new page before the group header does
not normally cause a blank page before the report.
Is there anything else that you may have included that
could cause the page feed?
Fons

 

[Ken Snell]

I usually accomplish this by setting the Group Header's ForceNewPage
property to No. Then I run code in the Group Footer's OnFormat event to turn
ForceNewPage on:

Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
On Error Resume Next
Me.GroupHeader0.ForceNewPage = 1
End Sub