I've got a report that that I use as an invoice and I want a certain textbox to be positioned on the bottom of the last page. Some invoices have only one page and some have two. I would put it in the Report Footer, except that if the data ends in the middle of the page, the textbox will be in the middle of the page as well. If I put it in the Page Footer, I think that it will print on the bottom of every page, which I don't want. Is it possible to do something like the following in the OnLoad event (or some other event) for the report?
- If Page = Pages Than
-
Me.text1.visible = True
-
Else
-
Me.text1.visible = False
-
End If
The only thing is I don't know if it will run it for each page. So if there is two pages, page 1 wouldn't have the textbox visable but page 2 would. Also, would I get the space to use for the data portion of the report?