Report Footer

[pocans]

I have a report with a page footer and a report footer. If the report is only one page the page footer is on page one and the report footer is pushed to an empty second page. I have property Page Footer: 'Not with Prt Ftr'. If the report is only one page is there a way not to display the page footer and have the report footer on the first page.

[isladogs]

Use the report Pages property

Try this - not tested

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)

If Me.Pages>1 Then
Me.PageFooterSection.Visible=True
Else
Me.PageFooterSection.Visible=False
End If

End Sub

[pocans]

This only make the page footer not visible. All this does is make the footer on page 1 blank and it still displays the report footer on the second page.

[pocans]

So more information. The report footer is forcing a new page no matter how many pages, how do you stop this from happening?

[June7]

What is the report footer ForceNewSection property set to?

[isladogs]

Various things to check

1. Have you got a page break control on your report - it look with a short dotted line
2. As June has already mentioned check the report footer settings:
Set Force New Page = None & Keep Together = No
3. Detail section - exactly the same as above
4. Page Footer section - Auto Height = Yes
5. Reduce the page margins at top & bottom
6. Move controls up slightly to reduce height of each section

Setting Force New Page = None and Keep Together = No for the footer section may be the most important
If part of the footer now appears on page 1 and the rest on page 2, then steps 5 & 6 should now fix it

[pocans]

currently the report footer's ForceNewSection property is set to none

[pocans]

Various things to check

1. Have you got a page break control on your report - it look with a short dotted line
2. As June has already mentioned check the report footer settings:
Set Force New Page = None & Keep Together = No
3. Detail section - exactly the same as above
4. Page Footer section - Auto Height = Yes
5. Reduce the page margins at top & bottom
6. Move controls up slightly to reduce height of each section

Setting Force New Page = None and Keep Together = No for the footer section may be the most important
If part of the footer now appears on page 1 and the rest on page 2, then steps 5 & 6 should now fix it

I set all of these and it stayed the same. But I was playing around with it. lets say I have a 2 page report. page 1 and 2 I see the page footer and page 3 report footer with a blank page.

If I set my report footer visibility to false and keep page footer to true, page 1 has the page footer and page 2 has no footer and the 3rd page is gone.
If I set my page footer visibility to false and my report footer to true, page 1 and 2 have no page footer and the 3rd page has the report footer with a blank page.

[isladogs]

Can you please do two screenshots of your original report
Design view and then print preview showing two pages side by side

[June7]

I do not get this issue with my report. So post either screen shots or the database. Follow instructions at bottom of my post.

[pocans]

Thanks for everyone's help. I ended up going a different way. since there was not a lot of extra information I needed on the last page I ended up getting rid of the report footer. Hid the information that needed to be shown on the last page and made them visible in the format of the page footer
if the page = me.pages
me.item1.visible = true
me.item2.visible = true
end if