Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printout Method

Status
Not open for further replies.

mmyers

MIS
Aug 8, 2001
25
US
Hello! I have a report that has several EIS sections that display charts, reports, pivots, etc. I want to add a button that will print out the chart, report, etc. I am trying to use the PrintOut(Method) command, but have a problem. One of the reports has several columns and the printout truncates the rightmost columns. Is there a way to let the printer know to print landscape? Or to a different pitch size (condensed).

Thanks for your help!
 
Mmeyers

In each report section set the Page Setup as you want it to print then save the document. This should preference should hold when you use the following:

ActiveDocument.Sections["REPORT"].PrintOut(false)

hth

Wayne Van Sluys
KeyPulse, Inc.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top