How to print my report in Landscape Mode

T

tim

After I designed the Inventory form, I found I could only
print the form in Portrait mode, no matter how many times
I tried to change to Landscape Mode in Page Setup Dialog
box. After failed numerous times, I tried to use the
following procedure in my AutoExec Module.
If Not IsNull(rpt.PrtDevMode) Then
strDevModeExtra = rpt.PrtDevMode
DevString.RGB = strDevModeExtra
LSet DM = DevString
DM.lngFields = DM.lngFields Or
DM.intOrientation 'Initialize fields.
DM.intOrientation = 2 'Landscape
LSet DevString = DM 'Update property.
Mid(strDevModeExtra, 1, 94) = DevString.RGB
rpt.PrtDevMode = strDevModeExtra
DoCmd.Save acReport, strName
End If

It failed again since rpt.PrtDevMode is always Null in my
database. I don't know what I should do.
 

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

Similar Threads

DoCmd Save Generates 2501 0
Save action cancelled 3
Setting Query to open on Lanscape and Legal 1
Interfacing to Adobe 3
Printing Report with Landscape and Portrait Settings 1
Print Report Landscape 1
How do I print in 'landscape' on A4 paper 1
All-in-one printing incompatibility with EXCEL in landscape mode 3

Top