How to open the Print Preview Window when printing a report in Access 2002.

[thevenin]

From Thevenin

I use the keyword acPreview in access 2000 to open the Print Preview window when printing a report. In the Print Preview window I can select which printer to use or the paper size etc.

When I use the same keyword acPreview in access 2002 the report goes straight to a view of the report and so does not allow the report to be printed.

Does anybody know of the correct keyword I should be using in access 2002 or can you tell me what I am doing wrong.

Thank you for any help you can give me.

 

[RuralGuy]

DoCmd.RunCommand acCmdPrint

 

[thevenin]

I am not sure what I am doing here, I am new tyoposting but the reply to my post was DoCmd.RunCommand acCmdPrint
What I want to know is where in the code do you open the report as the report name does not appear in the above DoCmd statement.

Thanks for your help RuralGuy

 

[RuralGuy]

That command opens the printer dialog. Just put it before you open your report for preview or print.

 

[thevenin]

Once again, thanks. It must be very nice where you live.


Thevenin