Change font color in report depending to value of date

[Guest]

I have a report listing some values out of a table/quiry.
The report is showing the names, job titles, company name, expery date on
medical report and some non essensial data .
My question or qest is to get this report to show different color on dates
on medical expiry when it is due to renew or nearing expiry date.
For example. When it is 3 months before expiry it shows green, when it is
expired red and if ok it's black.
I have read about conditional formatting as it is on excel but on my version
of access it's not here (or I haven't looked good enough).

when showing sql code on report it's like this:

SELECT Ansatte.[First Name], Ansatte.[Last Name], Ansatte.JobTitle,
Ansatte.Company, Ansatte.MedicalExpiry, Ansatte.CabinNo, [Job Title].[No]
FROM Ansatte LEFT JOIN [Job Title] ON Ansatte.JobTitle = [Job Title].[Job
Title]
WHERE (((Ansatte.Company)="Eidesvik") AND ((Ansatte.CabinNo)>"1"))
ORDER BY Ansatte.MedicalExpiry, [Job Title].[No];

table where info is stored is called "ansatte" and report name is "medical
expiry på skift"
I hope anybody can help me with this.
Many thanks for help

 

[Larry Linson]

What version _is_ your Access? It's a lot easier to answer questions with a
little information.

In Access 2003, you right-click a Control and choose Conditional Formatting
from the pop-up menu.

Larry Linson
Microsoft Access MVP