Change Default Print to B&W

[infomania]

I am using Access 2003. I would like all the reports in my application to print in B&W even though the screen preview may show some color. I have tried setting the printer properties to do this but it keep reverting back to Color on the next print.

Is there someway to set a global property when the application loads so that all reports will print B&W? For the printer I use (Leased network printer)we get charged extra for color copies even thought there is only B&W on the page.

Thank you.

 

[Remou]

Some stuff below that may be useful:

Calling The Printer Control Panel In VBA
thread705-615334

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acproPrtDevMode.asp

 

[infomania]

Interesting but not what I was looking for.

I was hoping to create a function in a module that would be used, somehow, to set the printer color option to B&W before calling the DoCmd.OpenReport.

Infomania
People do what you least expect from them. Expect more... get more.

 

[PHV]

Can't you define 2 printers (one color and one B&W) and then save your reports as using the B1W one ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[infomania]

That sounds like a solution, but how can I do this in the code? There is only one physical printer. And... how can I direct to report to the B&W printer using DoCmd.OpenReport?

Thanks you your feedback, PHV.

Infomania
People do what you least expect from them. Expect more... get more.

 

[PHV]

One physical printer may be defined twice in the window's printers panel ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886