A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Set page size to 11x17



 
 
Thread Tools Display Modes
  #1  
Old August 14th, 2009, 02:22 PM posted to microsoft.public.access.reports
QB
external usenet poster
 
Posts: 150
Default Set page size to 11x17

How can I set a report`s page setup paper size to 11x17 if none of the
printers I have access to allow that size (does not appear in the list), but
when deployed on the network my user have access to printers that allow it
(and the report requires that size to print properly)?

Thank you,

QB
  #2  
Old August 14th, 2009, 02:42 PM posted to microsoft.public.access.reports
Stephen Lebans
external usenet poster
 
Posts: 619
Default Set page size to 11x17

You must install/reference a Printer driver that supports 11 x 17 - even if
you do not have that specific printer physically attached to your computer.
As you stated, printers exist on your network that do support ledger size
ouptput.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"QB" wrote in message
...
How can I set a report`s page setup paper size to 11x17 if none of the
printers I have access to allow that size (does not appear in the list),
but
when deployed on the network my user have access to printers that allow it
(and the report requires that size to print properly)?

Thank you,

QB



  #3  
Old August 14th, 2009, 03:18 PM posted to microsoft.public.access.reports
QB
external usenet poster
 
Posts: 150
Default Set page size to 11x17

There is no way to set this using vba when the report is opened?

....Keeping in mind some users are in read-only mode cannot edit access
objects?

QB



"Stephen Lebans" wrote:

You must install/reference a Printer driver that supports 11 x 17 - even if
you do not have that specific printer physically attached to your computer.
As you stated, printers exist on your network that do support ledger size
ouptput.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"QB" wrote in message
...
How can I set a report`s page setup paper size to 11x17 if none of the
printers I have access to allow that size (does not appear in the list),
but
when deployed on the network my user have access to printers that allow it
(and the report requires that size to print properly)?

Thank you,

QB




  #4  
Old August 18th, 2009, 07:04 PM posted to microsoft.public.access.reports
Larry Linson
external usenet poster
 
Posts: 3,112
Default Set page size to 11x17

Could you select a PDF printer driver to get the setting. If you do not have
one on your machine, I have had good luck with the free open-source PDF
Creator from http://www.sourceforge.net.

Larry Linson
Microsoft Office Access MVP

"QB" wrote in message
...
There is no way to set this using vba when the report is opened?

...Keeping in mind some users are in read-only mode cannot edit access
objects?

QB



"Stephen Lebans" wrote:

You must install/reference a Printer driver that supports 11 x 17 - even
if
you do not have that specific printer physically attached to your
computer.
As you stated, printers exist on your network that do support ledger size
ouptput.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"QB" wrote in message
...
How can I set a report`s page setup paper size to 11x17 if none of the
printers I have access to allow that size (does not appear in the
list),
but
when deployed on the network my user have access to printers that allow
it
(and the report requires that size to print properly)?

Thank you,

QB







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.