A clause last on last page

A

Arni L

How do I set a clause (few labels) that will ONLY print
lowest on the LAST page (sometimes is the report 1 page
and sometimes longer). If the report is a single page
must the clause be on the first page base.
I can't use ReportFooter since it is always directly
behind the last record which can be on top of page.
Can I code this - I am very familiar with VBA.
Thanks,
Arni L.
 
F

fredg

How do I set a clause (few labels) that will ONLY print
lowest on the LAST page (sometimes is the report 1 page
and sometimes longer). If the report is a single page
must the clause be on the first page base.
I can't use ReportFooter since it is always directly
behind the last record which can be on top of page.
Can I code this - I am very familiar with VBA.
Thanks,
Arni L.
Click to expand...

If you don't already have a control computing [Pages], add a control
to the report. Set it's control source to
=[ Pages]
You can make it not visible if you wish.

Then, place the labels in the Page Footer.

Code the Page Footer Format event:

LabelName1.Visible = [Page] = [Pages]
LabelName2.Visible = [Page] = [Pages]
etc.

The labels will only show on the last page.
 
A

arnil

This was fine.
Have a nice weekend.
Thanks Fred.


-----Original Message-----
How do I set a clause (few labels) that will ONLY print
lowest on the LAST page (sometimes is the report 1 page
and sometimes longer). If the report is a single page
must the clause be on the first page base.
I can't use ReportFooter since it is always directly
behind the last record which can be on top of page.
Can I code this - I am very familiar with VBA.
Thanks,
Arni L.
Click to expand...

If you don't already have a control computing [Pages], add a control
to the report. Set it's control source to
=[ Pages]
You can make it not visible if you wish.

Then, place the labels in the Page Footer.

Code the Page Footer Format event:

LabelName1.Visible = [Page] = [Pages]
LabelName2.Visible = [Page] = [Pages]
etc.

The labels will only show on the last page.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Top