Print from Preview print screen, not report

[Guest]

In Access 2002, I look at a report in print preview, then change the printer
while still in preview mode, then print. What I get on the printer is the
underlying screen (from which the report was called), instead of the report.
Anyone know how to overcome this?

I tried using the code, as shown on The Access Web:
http://www.mvps.org/access/reports/rpt0015.htm and it works sometimes, but
not always. This problem has occurred in Access 97 as well. Auto-Correct is
off. The code changes the printer and then to print is:

DoCmd.RunCommand acCmdPrint

Thanks for your help.

 

[Guest]

Hi Catalina Diver,

Try inserting one line of code just prior to DoCmd.RunCommand acCmdPrint, as
in:

Docmd.SelectObject acReport, <report name>
DoCmd.RunCommand acCmdPrint

where <report name> is replaced with the actual name of your report.


Tom
_______________________________________

:

In Access 2002, I look at a report in print preview, then change the printer
while still in preview mode, then print. What I get on the printer is the
underlying screen (from which the report was called), instead of the report.
Anyone know how to overcome this?

I tried using the code, as shown on The Access Web:
http://www.mvps.org/access/reports/rpt0015.htm and it works sometimes, but
not always. This problem has occurred in Access 97 as well. Auto-Correct is
off. The code changes the printer and then to print is:

DoCmd.RunCommand acCmdPrint

Thanks for your help.