Portrait / Landscape Report


A

andrew

Hi

I am using Access 2000. I have 2 separate reports. One is in portrait
mode, then other is in landscape mode. I want to combine them into a single
printout such that one side displays in portrait and the other side displays
in landscape.

Can you give me examples of VB codes that tell Access to send the reports
one after the other and print the result into a single page?


Thanks


Andrew
 
Ad

Advertisements

U

UpRider

Andrew, here is some code to force landscape (or portrait). I'm not sure how
it applies in your case... Duplex printing depends on many variables
including the printer type. Anyway FWIW....
This code shows how to change the assigned printer also....

strDocName = "MyReport"
DoCmd.OpenReport strDocName, acViewPreview
'Lookup the printer to use for this report in the lookup
table...
strPrinter = DLookup("[sqlPrinter]", "tblSqlType", "sqlID ="
& Chr$(39) & txtSQLrec & Chr$(39))
If Len(strPrinter & vbNullString) > 0 Then
Screen.ActiveReport.Printer =
Application.Printers(strPrinter)
End If
Application.Reports(strDocName).Printer.Orientation =
acPRORLandscape
' or acPRORPortrait
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow

HTH
UpRider
 
Ad

Advertisements

U

UpRider

Andrew, just noticed you are using A2000. My just sent suggestion is
worthless for you. Has to be A2002 or better.
Sorry about that...

UpRider
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top