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

Changing Paper size in application

100+
P: 462
I have a report that can fix on letter size paper of on legal size depending on the number of columns that is printed on the report. I would like to change the paper size in the program depending on the number of columns printed. I've tried using the Application.Printer.Papersize = acRPSletter but it doesn't seem to change anything, is there another command that I need to do along with this?

Thanks
CD Tom
May 16 '09 #1
Share this Question
Share on Google+
3 Replies


mshmyob
Expert 100+
P: 904
Check out this post and see if it helps.

http://bytes.com/topic/access/answers/794305-paper-bin

cheers,

@CD Tom
May 16 '09 #2

100+
P: 462
That is exactly what I was looking for. Thanks
May 17 '09 #3

mshmyob
Expert 100+
P: 904
You're welcome.. Good luck with your project.

cheers,

@CD Tom
May 17 '09 #4

Post your reply

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