Query produces a list of items in a report.
For certain records in that report I need to change the font colour depending on the value of that record.Eg -

Header Title
------------------------------------
Detail Name Date
------ ---- -----
Chem 003837 test123 29/01/76
Main 008377 test345 23/08/98
Main 003783 test678 08/08/87
Chem 938333 test737 01/08/01

Where detail text box is Chem I need Red Font on printing.

try this in the On Format event of your detail section:

Me!Detail.ForeColor = RGB(0, 0, 0)
If Me!Detail = "Chem" Then Me!Detail.ForeColor = RGB(255, 0, 0)

hth,
al


[This message has been edited by pcs (edited 07-04-2001).]