Access Printer Preview

[onkeypress]

Hi huys,

Need to solve this problem. I need to print an Access Report (3 pages). For the first two pages (pages 1 and 2) they are in portrait orientation. For the last (page 3) page, it is in landscape orientation. How do I programme the report? I tried using the Printer.Orienta tion properties but it doesn't work. I need to show the 3 pages in its correct orientation in a single Print Preview Window.

Thanks in advance.

[PEB]

It seems strange!

The report for every data has the same structure... And the printer properties are availeble for all the report!

But however u can try to insert a subreport as 3-td page! I'm not sure that it will be good!

Pls tell us if this works!

:)

Best regards!

[PeterW]

If the report has always 3 pages, with the same content, then you can try to split it into 2 reports, one for the first 2 pages and the other for the third page. Each of them, of course, can then be designed separately. To print them you can put the printing commands one after the other, so that when you press the button (or whatever you do to print), the final result will be 3 pages, formatted as you desire.