Why does Access Report not pick up the default printer's settings.
Posted on 2014-01-31
I am developing an Access 2007 "project" (.ADP) as a front end to a SQL Server 2005 Express database.
On my client's Windows XP PCs, their default printers are configured to print in "Black and White" rather than "Colour" because their printer contract costs them GBP 0.08 per page for colour and only GBP 0.01 per black and white page.
In my Access Reports I try not use any colour, setting all borders and forecolours to black.
However, when I use the "DoCmd.RunCommand acCmdPrint" to print a Report, the usual Windows "Printer" dialogue box pops up with the correct default printer selected, but the "properties" button shows that its is going to print in "Colour", even though the page that eventually gets printed appears to have only black ink on it.
While the "printer" dialogue box is displayed, if a different printer is selected and then the "default" printer is immediately re-selected, the "properties" button reveals that print job will be "Black and White"? It seems that the printer's default settings are correctly read in when the printer is re-selected.
Why does my Access Report initially seem to override the printer defaults and want to produce a "Colour" print? Is there some sort of colour embedded in my reports somewhere? Is there a property (that I can't currently discover) in the design of my reports that would force them to be done in "black and white"?
Any help greatly appreciated.