C
cdolphin88
Hi,
I design a report in access and I put in the setup page as landscape..
then I use VB to print out the report..
The problem is I don't know why, it keeps printing in portrait and in 2
pages, instead of landscape...
Can I force to print in landscape? I try this line of code
Printer.Orientation = vbPRORLandscape but it doesn't work...
here's part of the code that I used in VB to print the report
Set app2 = New Access.Application
constrDBName = strdatasource
strReportName = "Rptlisting"
With app2
'Open DB
..OpenCurrentDatabase constrDBName
..Visible = True
'Open report to preview
..DoCmd.OpenReport strReportName, acViewPreview
'Print report
' Printer.Orientation = vbPRORLandscape
..DoCmd.OpenReport strReportName, acViewNormal
End With
Set appAccess = Nothing
Cheers!
Claudi
I design a report in access and I put in the setup page as landscape..
then I use VB to print out the report..
The problem is I don't know why, it keeps printing in portrait and in 2
pages, instead of landscape...
Can I force to print in landscape? I try this line of code
Printer.Orientation = vbPRORLandscape but it doesn't work...
here's part of the code that I used in VB to print the report
Set app2 = New Access.Application
constrDBName = strdatasource
strReportName = "Rptlisting"
With app2
'Open DB
..OpenCurrentDatabase constrDBName
..Visible = True
'Open report to preview
..DoCmd.OpenReport strReportName, acViewPreview
'Print report
' Printer.Orientation = vbPRORLandscape
..DoCmd.OpenReport strReportName, acViewNormal
End With
Set appAccess = Nothing
Cheers!
Claudi