Show only end of t

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I try to create a report, it will contain a label at the end of the report.
So I created a label on the report footer section in design mode.
But the label's location is not end of the last page, it locates end of the
report.
My report gets data from excel and number of pages change. My report's last
page may finish in the middle of the page.
I want to locate the label at the end of the LAST page only, not end of the
report or end of the all pages.
 
Yes, the report footer section is placed immediately under the previous
section's data.

Try a text box in the Page Footer, and set it's ControlSource to:
=IIf([Page] = [Pages], "Show this text", Null)
 
Hi,

I try to create a report, it will contain a label at the end of the report.
So I created a label on the report footer section in design mode.
But the label's location is not end of the last page, it locates end of the
report.
My report gets data from excel and number of pages change. My report's last
page may finish in the middle of the page.
I want to locate the label at the end of the LAST page only, not end of the
report or end of the all pages.
Click to expand...

You can place your label in the Page Footer.
Add a control to the page footer that computes pages, =[Pages].
If you don't wish to show the total number of pages, make this control
not visible.

The code the Page Footer Format event:
LabelName.Visible = [Page] = [Pages]
 
Back
Top