Show a Page Footer on last page only

  • Thread starter Thread starter jrh
  • Start date Start date
J

jrh

I have a report (Change Order) that sometimes runs more
than one page. There is a page footer that displays the
calculated total of all items on the Change Order and has
a line for customer's acceptance. Is there a way to
display the Change Order total and customer's acceptance
on the last page only of a multi-page Change Order? Also,
I need to keep this at the bottom of the page. I tried
Group Footers but that doesn't put the section at the
bottom of the page.
Thanks,
jrh
 
I have a report (Change Order) that sometimes runs more
than one page. There is a page footer that displays the
calculated total of all items on the Change Order and has
a line for customer's acceptance. Is there a way to
display the Change Order total and customer's acceptance
on the last page only of a multi-page Change Order? Also,
I need to keep this at the bottom of the page. I tried
Group Footers but that doesn't put the section at the
bottom of the page.
Thanks,
jrh
Click to expand...

To print the Page Footer only on the last page of the report:
Add a control to the footer to calculate [Pages]:
="Page " & [Page] & " of " & [Pages]
Then code the Page Footer Format event:
Cancel = Not [Page] = [Pages]

To display the Group footer at a specific location on the page:
See Microsoft KnowledgeBase article
208979 "ACC2000: How to Print a Group Footer at a Specific Location"
 
If you want to selectively hide one or more texrboxes I
have done it with the following in the onformat event of
the page footer:
Private Sub PageFooterSection_Format(Cancel As Integer,
FormatCount As Integer)
Me.Text22.Visible = ([Page] = [Pages])
End Sub
"Text22" is the box that in this cae will only print on
the last page.
Hope this helps.
FOns
 
Back
Top