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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing print preview after printing 8
Access Access Report Works on One Machine but not Another 3
How do I open my report in print preview mode in Access? 3
Print preview locks up, but Report view works (2007) 2
Print Preview != Report View 4
Print a report without displaying print preview 1
Form, instead of Report, Prints ??? 0
access report 0

Back
Top