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
 

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

Report Footer 4
Totaling Sums for Price and COMM 3
Blank area after fixed and variable height objects 4
Can't change height of group header 5
Calculate Subreport totals in a main report Group footer 3
One Record Per Page Printing-Access 2007 2
column width changes report header width 1
Page Orientation 1

Back
Top