Printer change - different reports

[Rolf Rosenquist]

I have a report as a receipt print out, that defaults to the standard
printer, which is a narrow printer with a paper roll. It works OK. But when
the user shall print a normal report in larger size of paper on a normal
printer, there are difficulties. Even if the report itself is set for that
printer, the margins and size of the narrow standard printer is messing it
all up.

The only way I could come up with, is that the user changes all the settings
every time a large report is to be printed. But also that he perhaps just
could change what is the standard printer for the moment? For that last
case, is there a way to open Windows printer choice from VBA code? Or any
other ideas?

/ Rolf

 

[Allen Browne]

In Access 2002 and 2003, you can set Application.Printer before you
OpenReport. This does not solve the issue of paper size though.

The alternative is to mess with the PrtMip settings, which is neither simple
nor intuitive. Details:
http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM

 

[Rolf Rosenquist]

Thanks for the link. I will see what I can find there.
/ Rolf