Change color based on date 1

[Garridon]

Is there are way for me to change the color of a particular row or field to red based on a date criteria? I have a report which lists suspenses and want to have either the row or the date turn red when the suspense is overdue.

Thanks!

Linda Adams (Garridon@aol.com)
"The Importance of Being Grammarian," published in The Toastmaster, March 2001

http://www.geocities.com/hallona_2000

http://www.david-hedison.com

 

[ghubbell]

Hi Linda,
Why sure! Say your date field is in the "Detail" section. In the "On Format" event of the detail section you'd do something like this:

If Me![NameOfDateField] > 2001/03/28 Then
Me![NameOfDateField].backcolor = vbRed
Else
Me![NameOfDateField].backcolor = vbGreen
End if

You can pick the colors by number if you prefer, and find the number by changing the color of a control on a form in design view, and watch its "Back Color" number change in its properties pop up dialog.

If your date field is in another section of the report, do the same but in that sections "On Format" event.

C'est Tout~That's all! Gord
ghubbell@total.net

 

[Garridon]

Thanks! This was a great help.

Linda Adams (Garridon@aol.com)
"The Importance of Being Grammarian," published in The Toastmaster, March 2001

http://www.geocities.com/hallona_2000

http://www.david-hedison.com