Print report in access 2007 runtime

[bodylojohn]

When I open MyReport using the following code:

DoCmd.OpenReport "MyReport", acViewPreview, "", "", acDialog

Access 2007 nicely shows me the report but I cant print it.

When I use:

DoCmd.OpenReport "MyReport", acViewPreview, "", "", acWindowNormal

I can print it but I cant display it in dialog.
So I get to see the tabs (forms) and a nice printpreview toolbar.

Is there a way arround it?
And I dont want to use a button.

 

[Sum Guy]

When the report is displayed on the screen, press the "P" key. The print menu will be displayed. Set your preferences and print away.

 

[bodylojohn]

When the report is displayed on the screen, press the "P" key. The print menu will be displayed. Set your preferences and print away.

Thank you very very much.

I will test that right away.