Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

HELP!! - Footer in a report!!

0 views
Skip to first unread message

Ken Getz

unread,
Feb 3, 2000, 3:00:00 AM2/3/00
to
In article <esWLbYib$GA.1524@cppssbbsa06>, bernardo...@iname.com
says...
> I would like to print a footer for a report but ONLY in the last page and in
> the footer of the page (I have to print it on a pre-impressed paper).
>
>
>
Put your footer text in the report footer section, in design view.

In the Print event of the Report Footer section, add code like this:

Private Sub ReportFooter_Print(Cancel As Integer, PrintCount As Integer)
Me.ReportFooter.Visible = (Me.Page = Me.Pages)
End Sub

That worked for me (just tried it to make sure). -- Ken

0 new messages