Print certain info only on bottom of last page

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Hi.

I want to print some information only on the last page AND
at the very bottom.

The Report Footer doesn't print at the bottom of the page.

The Page Footer prints at the bottom but on every page.

Is there a way I can get the Page Footer to print ONLY on
the last page?

Thanks
Lisa
 
For just one text box, you could use:
=IIf([Page] = [Pages], "Text you want to see here", Null)


If you need to print lots of text boxes, you could add a text box to the
Page Footer, and give it this ControlSource:
="Page " & [Page] & " of " & [Pages]
Then add this code to the page footer section's Format event procedure:

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As
Integer)
Me.PrintSection = (Me.Page = Me.Pages)
End Sub
 
Thank You!
So Simple, I've been farting around with the instructions
in the help and couldn't get it to work - your way works
great!
Lisa
-----Original Message-----
For just one text box, you could use:
=IIf([Page] = [Pages], "Text you want to see here", Null)


If you need to print lots of text boxes, you could add a text box to the
Page Footer, and give it this ControlSource:
="Page " & [Page] & " of " & [Pages]
Then add this code to the page footer section's Format event procedure:

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As
Integer)
Me.PrintSection = (Me.Page = Me.Pages)
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I want to print some information only on the last page AND
at the very bottom.

The Report Footer doesn't print at the bottom of the page.

The Page Footer prints at the bottom but on every page.

Is there a way I can get the Page Footer to print ONLY on
the last page?

Thanks
Lisa
Click to expand...


.
Click to expand...
 
Back
Top