Print report in access 2007 runtime (1 Viewer)

B

bodylojohn

Registered User.

Local time

Yesterday, 19:04

Joined

Dec 28, 2005

Messages

205

• Mar 10, 2008

• #1

When I open MyReport using the following code:

Code:Copy to clipboard

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

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

When I use:

Code:Copy to clipboard

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.

 

S

Sum Guy

Registered User.

Local time

Yesterday, 17:04

Joined

Nov 19, 2006

Messages

310

• Mar 11, 2008

• #2

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

 

B

bodylojohn

Registered User.

Local time

Yesterday, 19:04

Joined

Dec 28, 2005

Messages

205

• Mar 11, 2008

• #3

Sum Guy said:

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

Click to expand...

Thank you very very much.

I will test that right away.