Changing height, width and orientation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
Back
Top