Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Header/Footer 1

Status
Not open for further replies.

jtfrier

Technical User
Jan 12, 2006
85
I have a report that has a group in it to repeat and filter out duplicats I need to have a signature line on the last page of the report but the report footer seams to be linked to the group and when I Place the signature line in the report footer it places the text right under the grouped infroemation. not at the bottom of the last page . I cant put it in the page footer because I only want it to show up on the last page of the report.
 
If you only want the signature to appear at the bottom of the last page, try something like this:

In your page footer, if you don't have one already, add a text box whose control source holds the Page and Pages properties. Something like:

Code:
="Page " & Page & " of " & Pages
Make it invisible if you don't want it to appear. Place the Signature control in the Page Footer and set its Visible property to No.
In the On Format event of your page footer place code like this to make the Signature visible on last page of the report:


Code:
If Me.Page = Me.Pages Then
   Me.SignatureLine.Visible = True
End If

Si hoc legere scis, nimis eruditionis habes
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top