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

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

Post by bWFyazkwO » Fri, 08 May 2009 22:11:02


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 :)
 
 
 

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

Post by ken » Sat, 09 May 2009 01:08:51

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

 
 
 

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

Post by fred » Sat, 09 May 2009 01:17:46


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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail