Color MS Access Reports will only print in Black & White

I can not get MS Access to print Reports in color - it always prints in black & white (gray tone).

The reports are in color in Design View and Print Preview; but the hard copy is black & white.

I have tried this on several color printers (HP 3800N & Xerox Phaser 8400) with the same result.  The printers work correctly in other programs (like Excel, Internet Explorer, Powerpoint, Word, etc.), so I do not think it is the configuration, print drivers, or printers.

And I can "print" to the Microsoft XPS Document Writer, create the file, view it in color, and then print in color; so I believe that MS Access is capable of color output.  But I can not print directly from MS Access to a color printer in color.

I have gone through the Report attributes and I can not find anything that controls the color mode of the printer.

(There is a similar post for printing color PDF in MS Access, but that solution does not solve my problem)

Thanks!
Access57Asked:
Who is Participating?
 
omgangIT ManagerCommented:
Choosing Print from the File menu brings up the print dialogue box.  If I select a color printer and then choose the Properties button I see a 'Print In Grayscale' check box.  If this is checked the print will be in black and white.

OM Gang
0
 
omgangIT ManagerCommented:
What version of Access?
OM Gang
0
 
Access57Author Commented:
I have Access 2002, 2003 and 2007 software (I have tried all of them) - the file is formatted as 2002 - 2003.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Access57Author Commented:
I am not getting that option on my Xerox Phaser 8400 - it has several color options available, but everything is checked to output color.
The primary printer will be a Konica Minolta 2530 or and HP 3800N - I am in the process of checking those configurations, but it will take about an hour for me to get that done.  Will let you know when I have checked those.
0
 
Access57Author Commented:
Basically, your instruction helped me to get the production printer working porperly, which is my primary objective.  
The printer I use for development / programming purposes does not have this option available, so it is still not working in my office; but that is a secondary concern at this point.
Finally, I am still surprised it is a printer configuration issue because it only affected the MS Access Reports - everything else prints normally.
0
 
billdarronCommented:
If you open the report in design mode, and then change the "Page Setup" --> "Page" -->"Use Specific Printer" and change it to a color printer, then save, it usually fixes it.  Sometimes you need to switch between a few printers before it figures out that the one you want isn't a B&W only.  Also make the "Use Specific Prnter" NOT be your default printer when trying this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.