can i show a report to the screen prior to printing it?

[Karen Skipper]

I am working in Access2002 with a database that is in 2000 format and have
designed an interface for internal use. There is a whole page of buttons
that either print a report or show a form on the screen.

Is there a way to show the reports on the screen and then have it print,
maybe when the user closes the window the report is shown in?


Thanks in advance,

Karen Skipper

 

[Van T. Dinh]

You can at least show the Report on screen using the
appropriate value for the View argument of the OpenReport
Method.

Check Access VB Help on the arguments of the OpenReport
Method.

HTH
Van T. Dinh
MVP (Access)

 

[Charles Collins]

If you have a form you're using you can create a macro
that opens the report in print preview mode and inside
the macro you can open the report again in print mode. Or
you can have two macro's, one to open in preview mode and
the other to open in print mode. Add you a command button
to the form using the macro's.