Print a text only at the last page of the report

  • Thread starter Thread starter Angel_G
  • Start date Start date
A

Angel_G

How can I print a Text box or label box, only at the last page in the page
footer section. This would be a signature field so that when shipping prints
out the report then, they will only have to sign it once. I prefer the page
footer because if I use the report footer, the signature does not appear
always at the same location. Depending on the record amount sometimes it
ends up on its own page, at the top , middle, or bottom.
Any help on this is much appreciated.

Angel
 
How can I print a Text box or label box, only at the last page in the page
footer section. This would be a signature field so that when shipping prints
out the report then, they will only have to sign it once. I prefer the page
footer because if I use the report footer, the signature does not appear
always at the same location. Depending on the record amount sometimes it
ends up on its own page, at the top , middle, or bottom.
Any help on this is much appreciated.

Angel
Click to expand...

Place your Signature Label in the Page Footer.
If you don't already have one, add a control to the Page Footer to
calculate [Pages], i.e. = [Page] & " of " & [Pages]

Then code the Page Footer Format event:
[SignatureLabel.Visible = [Page] = [Pages]
 
Thank you so much!
fredg said:
How can I print a Text box or label box, only at the last page in the page
footer section. This would be a signature field so that when shipping prints
out the report then, they will only have to sign it once. I prefer the page
footer because if I use the report footer, the signature does not appear
always at the same location. Depending on the record amount sometimes it
ends up on its own page, at the top , middle, or bottom.
Any help on this is much appreciated.

Angel
Click to expand...

Place your Signature Label in the Page Footer.
If you don't already have one, add a control to the Page Footer to
calculate [Pages], i.e. = [Page] & " of " & [Pages]

Then code the Page Footer Format event:
[SignatureLabel.Visible = [Page] = [Pages]
Click to expand...
 
Back
Top