Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / June 2007

Tip: Looking for answers? Try searching our database.

paper size in page setup

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
-Hillary - 26 Jun 2007 01:28 GMT
I am using Access97 and I want to change all the report paper size in page
setup from letter to A4. How can I do this automatically instead of going to
every report and change it? Please let me know. Thanks.
Arvin Meyer [MVP] - 26 Jun 2007 03:27 GMT
Paper size is set at the printer in Windows, not at the report level in
Access. Changing the physical size of each report can be accomplished in
code by opening the report in Design View and changing the Height and Width
properties. That can be done in code, but the results are most likely going
to be disappointing, since nothing at all will be properly centered, and
controls too close to an edge may keep a report from being resized properly.
Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I am using Access97 and I want to change all the report paper size in page
>setup from letter to A4. How can I do this automatically instead of going
>to every report and change it? Please let me know. Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.