tags:

views:

26

answers:

2

I am using Access 2007 and I am trying to setup my report to print to a specific printer ( setup\page\use specific printer). But after I close and save the report, it goes back to the default printer. Why is this happening? I've never had this problem when I used Access 2003. I made sure that the designated printer is online and I successfully printed a test page. Please advise. Thank you

A: 

This link should help you out

http://www.mvps.org/access/reports/rpt0009.htm

You will have to set the printer to the one you want using VBA or it will just default back

Kevin Ross
The whole printer thing was updated in the 2003 version. The link applies to the 2000 version.
Remou
The PrintDevMode code should still work, but interacting with the printer device (actually introduced in A2002, not A2003) is substantially easier (though in my opinion, still not as easy as it ought to be).
David-W-Fenton
the hot fix didnt work. please advise
Nathaniel_613