473,325 Members | 2,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

How change printing options in Access 2002 reports

How do I widen the printing area for my report. The ruler shows I have set for an 8.5" page, and I have my margins set at .5". The area of my report being used is 5.5", but I can not find a way to make it print a wider report. Ultimately, I wish to print a 3 column document. I have no special effects.

Can anyone help
Mar 13 '07 #1
2 1929
ADezii
8,834 Expert 8TB
How do I widen the printing area for my report. The ruler shows I have set for an 8.5" page, and I have my margins set at .5". The area of my report being used is 5.5", but I can not find a way to make it print a wider report. Ultimately, I wish to print a 3 column document. I have no special effects.

Can anyone help
Here is a Method for programmatically changing the Layout Options for a Report:
Expand|Select|Wrap|Line Numbers
  1. 'If you want to change the Layout characteristics for a specific
  2. 'Report, you must work with the Print Layout Properties of the
  3. 'Printer Object for the Report as in:
  4.  
  5. Const conReport As String = "rptTest"
  6. Const conTwipsPerInch As Long = 1440    'dimensions are in Twips
  7.  
  8. 'Make all the modifications while the Report is Hidden, this is
  9. 'neat feature created in Access 2002
  10. DoCmd.OpenReport conReport, acViewPreview, , , acHidden
  11.  
  12. With Reports(conReport).Printer
  13.    .LeftMargin = 0.5 * conTwipsPerInch
  14.    .RightMargin = 0.5 * conTwipsPerInch
  15.    .ItemsAcross = 2   '2 Columns
  16.    .ItemLayout = acPRHorizontalColumnLayout
  17.    .DefaultSize = False
  18.    .ItemSizeWidth = 3 * conTwipsPerInch   'size of Detail Section
  19.    .ColumnSpacing = 0.1 * conTwipsPerInch
  20.    .DataOnly = True   'Print just data, no Borders, Gridlines, etc.
  21. End With
  22.  
  23. 'Magico!
  24. DoCmd.OpenReport conReport, acViewPreview, , , acWindowNormal
Mar 14 '07 #2
NeoPa
32,556 Expert Mod 16PB
How do I widen the printing area for my report. The ruler shows I have set for an 8.5" page, and I have my margins set at .5". The area of my report being used is 5.5", but I can not find a way to make it print a wider report. Ultimately, I wish to print a 3 column document. I have no special effects.

Can anyone help
It depends to a large extend on what is actually stopping it print wider.
Certainly, there is a .Width property of the report itself. This should at least be set to a value as wide as you want to use.
Mar 15 '07 #3

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

Similar topics

20
by: John | last post by:
Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet...
0
by: Mibbetson | last post by:
I am having trouble with Access 2002 randomly printing reports with all the information smashed up in the upper left corner of the paper. All the info is there, it is just really small. If a user...
0
by: Owen Jenkins | last post by:
I use the DoCmd.Printout method to print reports using the client's default options This has worked fine for years with Access 97 and 2000/2, Win95-XP. However two clients have recently complained...
3
by: RC | last post by:
I can't quite grasp the concept of creating custom reports depending upon what options a user picks on a Form. For example, the user clicks on a "Print Reports" button and a Form pops up. On the...
5
by: Lakbir Dhillon | last post by:
We converted our databases from Access 97 to Access 2002 (only the MDB files, not the MDW file). In addition we ported the Access application from a Citrix NT server to a Citrix XP server. We...
4
by: Jamey Shuemaker | last post by:
I've been looking for a way to do a duplex print job without a duplex printer. I reviewed some old posts about printing odd pages and found that most of them led to KB article 101075 or an export...
5
by: Hank | last post by:
My Access 2000 code has been running for several years in our main plant. Now we need to install it, as a stand-along application, at remote sites, some of which are out of state. My problem is...
1
by: Stinky Pete | last post by:
Hi, I've been reading, and successfully tested some code referred to in this group, that allows a user to select a printer before printing a report. The code has worked well on single page...
11
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RowSource of a Master Report is: Me.RowSource = "TableOrQueryName"
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.