Report in 2 formats

[errolf]

I have a report that needs more columns in first six pages and for the first six pages to be printed in Landscape format. The rest of the report is printed in Potrait format with a lesser amount of columns. Is there any way to change the format with code so that I don't have to print and collate 2 separate roports.
Regards
Errol Featherstone

 

[AnalystDBA]

Hi Errolf

Unfortunately there is no code that I know of that will format the page layout of a report in Access and I have looked into it in detail.
You can however open both reports in the one action so they display on screen on top of one another.
In VBA all you need to do is open both reports with the one subroutine

Example:

Private Sub Command1_Click()

Dim stDocName1 As String
Dim stDocName2 As String

stdocname1 = "Report1"
stdocname2 = "Report2"
DoCmd.OpenReport stDocName1, acPreview
DoCmd.OpenReport stDocName2, acPreview

End Sub

If you need any more help let me know.

Cheers.

AnalystDBA.