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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

printer paper size for data reports

Status
Not open for further replies.

chrisjs

Programmer
Sep 11, 2001
6
GB
Hi
Ive tried to use the printer object papersize property but it gets ignored when printing with the data report designer.
Here is part of my code:

Printer.PaperSize = vbPRPSA4

rptSummary.Orientation = rptOrientLandscape
rptSummary.Show vbModal

Is there an API I could use instead?

Any help would be much appreciated,
Thanks
Chris
 
fh,
Unfortunately this doenst seem to help. Orientation works OK as I have the latest sevice pack (SP5) but paper width isnt a property of the report designer, only of the printer object.
Thanks anyway,
Chris
 
Sam13 posted a message caption "VB Data Report Designer" on 5/31 and the last response was
generated on 12/06 (Pl. see the previous page).
As of my writing, that post has generated 55 responses (I am amazed!)
Following is the link:
Thread709-88923
Response from the top is from "whois (instructor)," he mentioned:
"height and width are for the reports container window, not the report"
Chris, I have not tried it, but that may be the answer???
Thanks,
fred


whois (instructor) wrote:
Just before you call the datareport.show method, set up the properties, such as:
deReporting.comAuthors
With drAuthorsDetail
'height and width are for the reports container window, not the report
.Height = 13965
.Width = 16965
.Orientation = rptOrientLandscape
.TopMargin = 400
.BottomMargin = 400
.LeftMargin = 400
.RightMargin = 400
'the caption is for the reports container as well.
.caption = strTitle
.Show vbModal
End With
There is alot more you can do - just play around a little.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top