Report design question

[Seth Schrock]

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?

[Mihail]

Is easy to see that. Open the report for preview.

[Seth Schrock]

If you are meaning that I should just give it a try, I will on Monday when I get to work. If that isn't what you are meaning, the I'm not sure what you are meaning.

[NeoPa]

Seth,

I think what Mihail is trying to say (I'm not sure, but he'd be correct to if he were) is that you should be checking this for yourself before posting the question. I know you don't have access to your project at the moment, and also that you get a lot of leeway as you contribute much yourself, but we do expect more preparation be done by members before posting questions.

As I say, as a helpful member yourself, I personally would be happy to help where possible anyway. Unfortunately, also due to the lack of preparation, the question is also pretty unclear and open-ended. I don't have the experience with reports I'd need to put you right, and your current position doesn't have much in the way of pointers to where best to look even.

Why don't you have a look at this again on Monday and tell us what you've tried and where, and we'll see what we can do to direct and assist if that is even still necessary.

[Mihail]

Yes. For both of you.

[sierra7]

Hi
Put the code in the On_Format event of the Page Footer.

It will work better if you use If..Then, rather than If..Than (typo!)
S7