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

's Computer Specifications

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

's Computer Specifications

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)

Jessica wrote:
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do you turn off auto update of date field	=?Utf-8?B?R2FiZXJpZWxsZSBHZWhyaW5n?=	Microsoft Word New Users	1	13th Apr 2006 05:22 PM
i have two date fileds Opend date Due date, can i set default on due date so, its always = to open date on my data entry form1 Urgent	Mike Saifie	Microsoft Access Form Coding	1	9th Mar 2006 01:08 AM
Invalid use if 'Null' on date field. Date field intentionally left blank	StarfishJoe	Microsoft Access Form Coding	2	21st Jun 2005 02:26 AM
Turn off date field updates	BR	Microsoft Word New Users	2	21st Mar 2004 01:39 AM
Date fields automatically changing when today date matches date field entry.Help!	Brian Cassin	Microsoft Access Forms	1	15th Nov 2003 01:51 PM