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

How change printing options in Access 2002 reports

P: 1
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
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,619
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
Expert Mod 15k+
P: 31,344
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

Post your reply

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