Edit "Page Setup" Variables in VBA

echovue · October 27th, 2004, 11:49 AM

I am designing a dynamic report that is built with VBA code, but will be run on different computers. Does anyone know how to access the variables that control the page margins from VBA?

Mike
EchoVue.com

SerranoG · October 27th, 2004, 12:00 PM

Well, if you define a printer object, you can set its margin.

Dim prtPrinter As Printer
prtPrinter.LeftMargin = 1440

This assumes that prtPrinter is your default printer. You can set .BottomMargin, .TopMargin, .LeftMargin, and .RightMargin. Note that the measurement is in twips.

1 inch = 1440 twips
1 centimeter = 567 twips

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

echovue · October 27th, 2004, 12:07 PM

Thanks, I'll give it a shot...

Mike
EchoVue.com

echovue · October 27th, 2004, 12:56 PM

Thanks for the help. I couldn't get a Printer Object to work in 2000, or 2003 for that matter, but using that as a basis to do some more searching, I found that with a report name of printReport, I could set the margin using printReport.Printer.TopMargin = 720, rather than declaring the printer object explicitly.

Thanks again

Mike
EchoVue.com