Header and footer showing on first and last page only

[WallT]

How can I get the Page header to show only on the first page, and Page footer to show only on the last page?

My report is a letter and will sometimes be long enough to go multiple pages.

Report footer doesn't show all the way to the bottom, so that doesn't work.

 

[Bandenjamin]

Remove the "page header/Footer" and change it to a Report Header/Footer.

Dan

Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body. But, rather to skid in sideways, chocolate in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO what a ride!

 

[WallT]

Unfortunatley that doesn't give me the desired look. The header is not a porblem, but the footer I want on the "very bottom" of the last page...even if the report data ends at the top...Report Footer will appear at the end of the data not the bottom of the last page...

 

[dhookom]

You can use code to hide the sections based on the page and pages variables of the report. This requires you bind a control to something like:
=[Page] & " of " & [Pages]

In the On Format of the section....

Cancel = [Page]<>1

or

Cancel = [Page]<>[Pages]

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]