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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Scott McDaniel (Microsoft Access MVP - EE MVE )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"

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.