Open up report in print preview from macro but showing 2 pages???

[mark909]

In a Form ive set up ive created a Label with an Emdedded Macro that opens a
Report in Print Preview View when clicked.

This opens up a Print Preview showing the first page only. I was wondering
if it is possible to set up the print preview so it will display two pages
when it opens?

Thanks for any help

 

[ken]

Using code:

DoCmd.OpenReport "YourReportName", View:=acViewPreview
RunCommand acCmdPreviewTwoPages

The macro equivalent to the second line would be to call the
RunCommand action with PreviewTwoPages as the command

Ken Sheridan
Stafford, England

 

[fredg]

In a Form ive set up ive created a Label with an Emdedded Macro that opens a
Report in Print Preview View when clicked.

This opens up a Print Preview showing the first page only. I was wondering
if it is possible to set up the print preview so it will display two pages
when it opens?

Thanks for any help

In code you could use:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdPreviewTwoPages


If you use macros, there is a RunCommand action with a PreviewTwoPages
command.

 

[mark909]

awesome thanks guys!

Using code:

DoCmd.OpenReport "YourReportName", View:=acViewPreview
RunCommand acCmdPreviewTwoPages

The macro equivalent to the second line would be to call the
RunCommand action with PreviewTwoPages as the command

Ken Sheridan
Stafford, England