Footer on 1st page different from all other pages

[Susan]

I have a report that can be from one to around ten pages long. I need a page
footer that containes the page number and another label on ALL pages, but on
the FIRST page only, I need additional labels and text boxes.

I know how to make the page header not print on pages with a report header
or footer, I thought maybe I could use some variation of the report footer,
and cause it to print on the first page instead of the last, but no luck.

Is there some way to maybe make those fields needed on the first page only
to be visible only if the page number is one, and not visible on all
others....then maybe set can shrink to eliminate the extra space on the other
pages???

Thanks for any help!
Susan

 

[fredg]

I have a report that can be from one to around ten pages long. I need a page
footer that containes the page number and another label on ALL pages, but on
the FIRST page only, I need additional labels and text boxes.

I know how to make the page header not print on pages with a report header
or footer, I thought maybe I could use some variation of the report footer,
and cause it to print on the first page instead of the last, but no luck.

Is there some way to maybe make those fields needed on the first page only
to be visible only if the page number is one, and not visible on all
others....then maybe set can shrink to eliminate the extra space on the other
pages???

Thanks for any help!
Susan

Code the Page Footer Format event:
Me![ControlName].Visible = Me.[Page] = 1
Do the same for each additional control you only wish to show on Page
1.

The Page footer does not have a CanShrink property so you can't adjust
the height of the Page Footer section.