Show a Page Footer on last page only

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

On Wed, 19 May 2004 08:05:29 -0700, jrh wrote:

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

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"

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

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
-----Original Message-----
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
.