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
2 1929
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: - 'If you want to change the Layout characteristics for a specific
-
'Report, you must work with the Print Layout Properties of the
-
'Printer Object for the Report as in:
-
-
Const conReport As String = "rptTest"
-
Const conTwipsPerInch As Long = 1440 'dimensions are in Twips
-
-
'Make all the modifications while the Report is Hidden, this is
-
'neat feature created in Access 2002
-
DoCmd.OpenReport conReport, acViewPreview, , , acHidden
-
-
With Reports(conReport).Printer
-
.LeftMargin = 0.5 * conTwipsPerInch
-
.RightMargin = 0.5 * conTwipsPerInch
-
.ItemsAcross = 2 '2 Columns
-
.ItemLayout = acPRHorizontalColumnLayout
-
.DefaultSize = False
-
.ItemSizeWidth = 3 * conTwipsPerInch 'size of Detail Section
-
.ColumnSpacing = 0.1 * conTwipsPerInch
-
.DataOnly = True 'Print just data, no Borders, Gridlines, etc.
-
End With
-
-
'Magico!
-
DoCmd.OpenReport conReport, acViewPreview, , , acWindowNormal
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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"
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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
|
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...
|
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...
| |