Page Footer alone (Access2003)

Topic

New Reply

Pleased, help me to not to print page header with page footer.
I want pafe footer to be printed after the Report data but IF on anew page – than Page Header shouldn’t be there. Thanks

Reply | Quote

Replies

I’m not entirely sure what you mean, but see if the following does what you want:

1) Make sure that there is a text box in the page header or footer that refers to [Pages] (the number of pages in the report), for example with a control source of

=[Pages]

or

=”Page ” & [Page] ” of ” & [Pages]

2) Write code for the On Format event of the page header, e.g.

Private Sub PageHeader_Format(Cancel As Integer, FormatCount As Integer)
Cancel = (Me.Page = Me.Pages)
End Sub

where PageHeader is the name of the page header section.

Reply | Quote

I am not sure if this will do what I want.
I have a page footer with “Page ” & [Page] ” of ” & [Pages]and it has different Label with text for the page footer.

Now I need a Report footer to display text after the whole Report.
It does work but Page Header is coming up as well,
It use to be where you can select Except Report Footer for the Page Header to be displayed on every page except when this page displaying Report FOOTER, I can’t find this property…
Thanks

Reply | Quote

Open the report in design view.
Activate the Format tab of the Properties window.
Make sure that the Caption of the Properties window says Report.
Set the Page Header property to “Not with report footer”.

Reply | Quote

Thanks so much.

How can I say ‘do not print label in Page Footer if it is a last page’? Because NOW there is a Report Footer’s label there. So I want to take page footer’s label out just from last page.

THANKS

Reply | Quote

Is the label the only control in the page footer, or does the page footer contain other controls that should remain visible?

Reply | Quote

The line and Page of Pages is there as well. They should remain visible OR if it is esier by much – don’t.
Thanks

Reply | Quote

You can use code in the On Format event of the page footer:

Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer)
Me.LabelName.Visible = Not (Me.Page = Me.Pages)
End Sub

Where PageFooter is the name of the page footer section and LabelName is the name of the label that you want to hide on the last page.

Reply | Quote

I appreciate your help…as those other 1000 times…:-))

Reply | Quote