Changing height, width and orientation

P

Phil

Hi,
Can a Report height, width and orientation be changed on the ON-Open event
of the report? My report has no header or footer, only a detail section. If
this can be done, how? Everything I’ve tried didn’t work.

Thanks,
 
A

Allen Browne

In Acess 2002 or 2003, you can use the Printer object of the report once it
is open in Preview to change the margins and orientation.

This example sets the margins to 1/2" and orientation to landscape:

Const lngcMargin = 720&
With obj.Printer
.TopMargin = lngcMargin
.BottomMargin = lngcMargin
.LeftMargin = lngcMargin
.RightMargin = lngcMargin
.Orientation = acPRORLandscape
End With
 
Top