diary dates & current date

  • Thread starter Thread starter AL904
  • Start date Start date
A

AL904

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
 
Back
Top