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

  • Thread starter Thread starter mark909
  • Start date Start date
M

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 :)
 
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
 
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 :)
Click to expand...

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.
 
awesome thanks guys!

[email protected] said:
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
Click to expand...
 
Back
Top