View Full Version : Rpt - force footer to Bottom of last page


Claire_Lawson
07-09-2003, 02:10 AM
Hi

I am developing a fairly straightforward database to generate invoices - I'm nearly finished but have come up a problem with Footer Placement

I need to have a footer at the bottom of the last page of the invoice (usually 1 or 2 pages) - it's for a perforated tear-off remittance slip (ie the last 4cm of an A4 page)

I have tried page footers, which appear on every page and I cant see how to anchor the report footer to a specific position

any ideas - it's getting late and my head hurts!

:confused:

Awes
07-09-2003, 04:08 AM
Hi Claire

To get it to display only on the bottom of the last page I would use the Report Footer rather than the Page Footer.

When you are in the report design view click on the View drop down menu and click on Report Header/Footer to display it and then you should be able to put what you want in the Report Footer.

Hope that helps

AWES

Rich
07-09-2003, 07:48 AM
Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page = Me.Pages Then
Me.Section(4).Visible = True
Else
Me.Section(4).Visible = False
End If
End Sub
where section 4 is the PageFooter