I am trying to force a report to print in Black & White even if the default printer it is sent to is a Color Printer. In the Open event of the Report, I have the following VBA code: Me.Printer.ColorMode = acPRCMMonochrome. When I print from the Navigation Pane (right-click on the report and select "Print..."), the report prints in Black & White like I want it to. However, when I use DoCmd.OpenReport RptName, acViewNormal... from a Form, it prints in Color, which is not what I want. In both cases, the default printer is a Color printer and this same printer is used in both cases.
Note: I'm aware that we could define the printer as a Black & White only printer, however, there are reasons this is unacceptable.
Thanks for any ideas.