Printing Command

[jeff]

The command print (DoCmd.RunCommand acCmdPageSetup) works great. However
when the command is executed you can not see the report until after the
command is executed. I will like to know how to show the report first then
print....

NOTE:
The command is executed from a form.

 

[Steve Sanford]

Have you tried:

DoCmd.OpenReport "YourReportNameGoesHere", acViewPreview


If you use "acViewNormal" (the default) instead of "acViewPreview", the
report prints without the preview.

HTH

 

[jeff]

Yes, I tried that command code, then I enter the DoCmd.RunCommand acCmdPrint

There is a small pause then the print menu comes on but there is no report
view.

Jeff-

--

 

[Steve Sanford]

I have (so far) 24 reports in my MDB. I have a list box that, when double
clicked, opens the selected report in preview mode. The command I use is (for
one report):

DoCmd.OpenReport "rptCurrentRates", acViewPreview


The report opens in preview mode, thenI print it using the printer button in
the menu bar. No other code required. Then I click on the Close button in the
menu bar.


What other code is in your Sub???

HTH