Report(2 Pages View) (A2k)

Topic

New Reply

Is there a way to view report in print preview and automatically force it to be in the 2 pages view?
I didn’t see any references to this in VBA help.
Thanks,
Scott

Reply | Quote

Replies

Recommend use the acCmdPreviewTwoPages command. Example:

Sub OpenReportTest()

DoCmd.OpenReport “Report1”, acViewPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdPreviewTwoPages

End Sub

This opens the report, maximizes window, and displays it in two-page mode.

HTH

Reply | Quote

Thanks,
That did the trick.
I guess I didn’t put in the right search criteria in the help screen.
Thanks,
Scott

Reply | Quote

Thanks,
That did the trick.
I guess I didn’t put in the right search criteria in the help screen.
Thanks,
Scott

Reply | Quote

Recommend use the acCmdPreviewTwoPages command. Example:

Sub OpenReportTest()

DoCmd.OpenReport “Report1”, acViewPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdPreviewTwoPages

End Sub

This opens the report, maximizes window, and displays it in two-page mode.

HTH

Reply | Quote