I have an mde written in Access 97, converted to A2000, and used by
all flavours of Access from 97 to 2010. One of the reports includes
code to change the colour of one field from black to red, by setting
the ForeColor property of the report field when the report opens.

If Forms![SetupF]![ColourReminders] = True Then
If [DocumentType] Like "*Reminder*" Then
[OverdueMessage].ForeColor = 255
End If
End If

This works fine on the preview, and usually on the printout. However,
some clients find that the printed report either prints the red field
in black, or a variant of colour that is not red. This is despite the
printer printing colour perfectly well from other applications.
Reinstalling the printer driver does not help. Any suggestions?

Owen

On Sep 27, 5:14*am, Owen <goo... (AT) healthbase (DOT) com.au> wrote:
Would it not be better to write:
[OverdueMessage].ForeColor = RGB(255,0,0)

??

Jim

On Sep 27, 5:14*am, Owen <goo... (AT) healthbase (DOT) com.au> wrote:
[OverdueMessage].ForeColor = RGB(255,0,0)

??


Jim

Hi Jim,

Thanks, I guess so, but RGB(255,0,0) evaluates to 255 anyway, and
makes no difference to this problem.

Owen

On 28/09/2011 05:03:33, Owen wrote:
Random thoughts.
Code looks OK and the problem seems to be with the printers, not Access.
Are the reports printed on the Default Printer, if so how are they set up? -
for each location Have the printers run out of red ink?
Have the printer drivers been updated?
Phil

Drivers are up to date, ink is full, printer is default.
Owen