Hi,
I'm reasonably sure that this issue isn't related to the database as
such. I have an Access 2003 report with a couple of coloured logos on
it that was printing fine, but now the logos only print in black and
white.
They display OK on screen and other coloured documents from MS Word
etc can be printed OK to the printer in question. If the report is
first pdf'd and then sent to the printer the logos print in colour as
they should.
You could try to set the Colormode of your report ( On Open ) :
Reports(Me.Name).Printer.ColorMode = acPRCMColor
An other solution could be to export your report to a text file as follows :
Application.SaveAsText acReport, "ReportName", "PathAndFilename.txt"
In that text file you delete the following sections :
PrtMip
PrtDevMode
PrtDevNames
After doing that, you can re-import your report as follows :
Application.LoadFromText acReport, "ReportName", "c:\exp.txt"
Please be aware, that some page settings ( i.e. margins ) could be lost, so
that it's recommended only to use a copy of your report.
Regards
Jens