How can i program a date field to turn red when the date is due

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jessica - 06 Jul 2005 19:40 GMT

I have a date field call Recon Due. Every month i need to be checkin which
recons are due for the month. But i would like the field to turn a different
color 2 weeks before is due. For example if i have one due on 7/25/2005 i
would like for that field to turn Blue and when it's past due i would like it
to turn red

Reply to this Message

David C. Holley - 06 Jul 2005 19:57 GMT

Set the Conditional Formating for the field. All of the info is in help
if you need it. (Right click on the field and select Conditional Formating)

> I have a date field call Recon Due. Every month i need to be checkin which
> recons are due for the month. But i would like the field to turn a different
> color 2 weeks before is due. For example if i have one due on 7/25/2005 i
> would like for that field to turn Blue and when it's past due i would like it
> to turn red

Reply to this Message