Changing Report From Portrait to Landscape In VBA

[DISI]

I have a multi-page report that contains many tables. I must start the report to print page-1 in Portrait, then shift to Landscape for page-2, then sift back to Portrait for page-3. (I have no option to keep the page orientation consistent.)

I am looking for VBA that will not only set/change page orientation, but also set margins. I am using MS Access 2007 and am printing to a PDF file.

Thank you.

Paul

Paul Faculjak
paul@DataIntegritySolutions.com

 

[genomon]

We do exactly this with the new printer object. Be sure and download the sample mdb as much of the code you need has already been written:

http://msdn.microsoft.com/en-us/library/Aa139946(office.10).aspx

Gluais faicilleach le cupan làn

 

[DISI]

Thank you for your reference. Unfortunately, I am a novice using VBA, so this level of printer manipulation is beyond my ability to tackle. I have saved your reference for someday in the future.

Much appreciation. Paul

Paul Faculjak
paul@DataIntegritySolutions.com