Page Break - 1 pg portrait 2nd page landscape

[Kathy S]

Does anyone know if you can create a 2-page report in Access where the first
page is in portrait and the second page is in landscape?

 

[John Spencer (MVP)]

I know of no way to do this in Access.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[lucky33]

Does anyone know if you can create a 2-page report in Access where the first
page is in portrait and the second page is in landscape?

When I had to create a project like this I created two seperate
reports one page that you need to print portrait and one report for
the page that you need to print landscape.

After creating those two reports create a new report and insert the
two reports above as subreports. If you have a button to print the
report have it point to the third report that you created.

This might not be the cleanest way to get this done but it did work
for me.

Hope this helps

 

[John Spencer (MVP)]

Wow, I am surprised that your solution works. I was always under the
impression that the report controlled the elements such as page orientation,
paper size, etc. The sub-reports simply used the main report's settings.

I guess I will have to remember to test this.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County