changing page Orientation Mid Report 1

[Fubear]

I have a three page report, page 1 needs to be protrait, page2 needs to be landscape, and page 3 needs to be protrait.

How can i set this up in Access, if i try to change the page layout it changes for all pages.

 

[Fubear]

Ignore - I did a search - apparently it cant be done

 

[LittleSmudge]

Of course it can be done.

EVERYTHING is possible - it just depends on HOW MUCH you really want to do it.


Create two reports
rptFirst contains the layout to appear BEFORE the orientation change
rptSecond contains the layout after the orientation change

In the OnPrint event of rptFirst get it to set a global variable to the max page number

Then on the OnOpen event of rptSecond set the StartPageNumber to GlobalPageNumber + 1


Then print both reports.


'ope-that-'elps.

G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D