How do I print a report in color using Access 2007

I'm printing a report in Access using the follow command:
stDocName = "rptCaseMgt_Invoice_Type1_Report"
DoCmd.OpenReport stDocName, acViewNormal

The report prints in Black & White even though the printer's default settings is for color. I tried this on several printers all with the same result.
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Open your report in Design view, and open the Page Setup dialog. Locate a COLOR ONLY printer, if possible, and set that as the printer. Save the report.

If that doesn't work, try a different printer (if possible).

Double (and triple) check the settings for the printer - make sure that "use gray scale" is NOT checked for this.

Also try changing the "Default Printer" setting to "Use Specific Printer" (after selecting your color printer, of course).

You might also try using code to manage this:

DoCmd.OpenReport "YOurReport", acViewPreview
Reports("YourReport").Printer.ColorMode = acPRCMColor
'/now 'print" it
DoCmd.OpenReport "YourReport", acViewNormal
DoCmd.Close acReport, "YourReport"
Tony HungateDirector of TrainingCommented:
My first thought here is to make sure that you are using the most updated printer diver possible. Go to the manufacturers website and ensure you have the latest and greates.  Then ensure that you get it setup exactly the way that you want it.

Once you have completed that try this as well.
Go to file > Page Setup > Page Tab.  Select use specific printer, click on printer. Select your printer, click on properties. Make sure the settings are correct here as well.

Good luck.

It is to say that modern operating systems are all WYSIWYG-  if the report is colored when viewing it, the printed output will have the same colors.  Remember you need to set the colour of all the contents of the controls on a report before you will see it in print.  Same for the background of the various sections Header, Detail, etc.
Jeffrey CoachmanMIS LiasonCommented:
<The report prints in Black & White even though the printer's default settings is for color. I tried this on several printers all with the same result.>
In my experience, if the Preview is B&W, the actual printout will be B&W also.

Check your Printer Driver.

Make sure that if your printer can print Color, that the mechanism to print in color is in place...
(Correct cartridges installed, and fully loaded...)

Unfortunately, many printers won't tell you that the color cartridges are not installed, they simply only display B&W.

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.