Preview report

  • Thread starter Thread starter BW
  • Start date Start date
B

BW

Is there a way to have a report (using the preview screen) to come up with
the "view" showing 2 full pages? I know I can go the toll bar and select
the button to show two pages but I would like to tell it when opening the
report to do this automatically.

Thanks
Brent
 
Is there a way to have a report (using the preview screen) to come up with
the "view" showing 2 full pages? I know I can go the toll bar and select
the button to show two pages but I would like to tell it when opening the
report to do this automatically.

Thanks
Brent
Click to expand...

Open the report from and event on a form:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdPreviewTwoPages
 
BW,
Use this code to open the report...
DoCmd.OpenReport "rptYourReportName", acViewPreview
DoCmd.RunCommand acCmdPreviewTwoPages
 
Back
Top