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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Writing VBA Code to control the background color of a form field 2
Conditional Formatting- Changing Color When A Date has been Reache 3
Report to Filter on Next Date Per File 2
Due date - change cell color 2
Can't change the cell back to blank when there is a date in it. 0
AutoFill null date 1
Can I make Access send a flag when a date field is nearing? 4
How to turn off behavior that turns past "Due By" dates red? 3

Back
Top