Variable Page Widths in Reports

[RyanP]

Is there any way to have the Report width (page layout) flip into landscape for only select pages of a report (those containing landscape oriented imagery / maps which are loaded into the report as image controls)

e.g. X pages of Portrait orientation pages, followed by X pages of Landscape or flipping between Portrait & Landscape throughout...

Method 1 (Ideal): able to have the report go back and forth between portrait and landscape
Method 2 (OK): Push all the landscape pages to the end (If so, how can you configure bookmarks within the report (that would be transferable to the subsequent PDF export)

With method 2; Creating 2 reports and combining them would work... (with bookmarks / all automated?)

We currently do this as a post processing task in Adobe Acrobat, but I would like to automate it in Access do we can ditch Acrobat altogether due to the subscription fees.
Not entirely adverse to Access / Acrobat automation as well... have not personally been able to find much (free) information in this regard online...

(related question: How to set the Image Control dimensions independently for each image in a report. Would do this in tandem with the variable page widths)

[CJ_London]

There are a number of options for changing orientation - which is right for you depends - google 'access vba change report orientation' for a number of solutions. Not sure where you would apply the code, you will need to experiment - suggest maybe the on format or on page events

related question: How to set the Image Control dimensions independently for each image in a report.

use the move functionality to set left, right, width and height values, or use the left, right, width and height properties independently e.g.

myimagecontrol.move 0,0,100,200

or

myimagecontrol.width=400

[ItsMe]

I have never tried to accomplish this but I would guess it is not possible. If I were trying to get it done, I would brush up on the Page property and see if I could get the page numbers to Debug.print at specific key values. I would place VBA in the On Format event of a specific section of my report. Depending on what approach I took, I may be interested in the value of the On Page property, also.
https://msdn.microsoft.com/EN-US/lib.../ff195525.aspx
https://msdn.microsoft.com/EN-US/lib.../ff835059.aspx

From there, you would have to get the Printer and go after its properties. As far as I can tell, the Printers Collection is just under the Application layer. So I do not think you will have much success adjusting the printer while the report is being rendered. I have had enough trouble just trying to select a specific printer for a specific Reoport Object, let alone adjusting the printer properties on the fly. Maybe something like

Me.Printer.Orientation = acPRORLandscape

https://msdn.microsoft.com/EN-US/lib.../ff193183.aspx
https://msdn.microsoft.com/EN-US/lib.../ff198274.aspx

The only way is probably to print or export to PDF and then Automate Acrobat via Access.
I would probably render two reports, one in landscape and one in portrait. I would use info from the Report's Page Property or search for text in the PDF file after it was rendered. With the page numbers in hand, I would create a new PDF file using Acrobat Automation.

[June7]

I think still must have Adobe Acrobat (not Reader or Distiller) installed for the automation to work. Or maybe with other software https://groups.google.com/forum/#!to...ss/b42SlQI5xKE

[ItsMe]

I think still must have Adobe Acrobat (not Reader or Distiller) installed for the automation to work.

Correct, the machine that executes the code to Automate Acrobat will need to have Acrobat installed. I suspect there is a way to do it with Acrobat installed on only one machine.