asked on

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.

Tony Hungate

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.

~:TLH:~

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

GRayL

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 Coachman

<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.

JeffCoachman