By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,102 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Report design question

Seth Schrock
Expert 2.5K+
P: 2,932
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?

Expand|Select|Wrap|Line Numbers
  1. If Page = Pages Than
  2.      Me.text1.visible = True
  3. Else
  4.      Me.text1.visible = False
  5. 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?
Jan 6 '12 #1

✓ answered by 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

Share this Question
Share on Google+
5 Replies


100+
P: 759
Is easy to see that. Open the report for preview.
Jan 7 '12 #2

Seth Schrock
Expert 2.5K+
P: 2,932
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.
Jan 8 '12 #3

NeoPa
Expert Mod 15k+
P: 31,307
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.
Jan 8 '12 #4

100+
P: 759
Yes. For both of you.
Jan 8 '12 #5

Expert 100+
P: 446
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
Jan 9 '12 #6

Post your reply

Sign in to post your reply or Sign up for a free account.