Printing PAGE FOOTER only on 1st page

[indyaries]

Greetings,

I have a form that display an employees Performance Plan, which is based on the employees job description. I have created this report to match the actual paper form this info normally appears on.

The report is set up thus:
The PAGE HEADER contains generic Form information, plus includes fields from the database, such as employee name, SSN, job title, grade, etc. It also contains the heading for the second part of the form, called PART II - PERFORMANCE ELEMENTS AND STANDARDS.

The DETAIL section of the Access report contains a field for the JobElement, Critical Element, and Performance Standards.

The PAGE FOOTER contains the authentication information, which are merely boxes and labels to hold supervisor and employee name and date signed information. Note that this part of the report is blank, and used only when printed, as it requires written signatures.

MY DILEMA: These Performance Standards most times require more than one page for all of the job elements. I only need the information that is in the PAGE FOOTER to display and print for the first page only.

How can I set all of the labels and boxes in the PAGE FOOTER to only print for the first page of the report?

Thanks in advance !!

Bob
aries170@comcast.net
robert.cole@dfas.mil

 

[Craig0201]

Bob,

Sounds like this should be the LAST thing on the report.......I wouldn't sign (most) documents in the middle, but at the end.......try it as a report footer.

Craig

 

[mrf1xa]

If it is really necessary to have this on the first page only, then put this code in the On Print event of the footer section of your report:

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

It should give what you want.

Nigel