PDA

Click to See Complete Forum and Search --> : Change Report Orientation in Access '97


ernmeister
Sep 13th, 2000, 10:28 AM
I am trying to set page properties for a report through VB. Using the following code, I should have all margins set to .250". However, when I run the program the margins get set as:

Top = 5.373"
Bottom = 5.373"
Left = 4.123"
Right = 4.123"

If I remove the lines refering to the Top, Bottom and Right margins and leave the line referring to the Left margin, it will set the Left margin at .25".

PrtMipString.strRGB = rpt.PrtMip
LSet PM = PrtMipString
PM.intLeftMargin = 1 * 360
PM.intBotMargin = 1 * 360
PM.intTopMargin = 1 * 360
PM.intRightMargin = 1 * 360
LSet PrtMipString = PM
rpt.PrtMip = PrtMipString.strRGB

Also, I want to set the orientation to Landscape. How is that done?

I will greatly appreciate any help I can get.

Thanks,
ern