I have a form that has 4 fields on that have diary dates in them “Diary Date
“ & [ServeDate] + 21 the field update would look like “Diary Date 4/28/2010”.
The form updates on open with a marco. What I would like to do is if the
current date is greater then the Diary Date, is change the color of the font.
Is this possible.

Yes.

Use conditional formatting.

In design view, click on the control and then select Conditional formatting
from the menu.

Expression is: [DiaryDate]> Date()

Then select a font color for the that condition.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

AL904 wrote:
> I have a form that has 4 fields on that have diary dates in them “Diary Date
> “ & [ServeDate] + 21 the field update would look like “Diary Date 4/28/2010”.
> The form updates on open with a marco. What I would like to do is if the
> current date is greater then the Diary Date, is change the color of the font.
> Is this possible.