Conditional Formatting-Access 2002

G

gail

Hi,
Can anyone help me? I'm trying(unsuccessfully)to set
conditional formatting, using the following criteria,
based on the value of a "Date Due" text box:

1)"Date Due" text turns red-once the due date has passed;
2)"Date Due" text turns dark green 5 days prior to and
including due date.
3)"Date Due" text is regular green by default.

I'd appreciate anything you could do...and thank you!!
 
B

Bill Taylor

conditional formatting:
field value is less then Date() text = red
field value is Between Date() And Date() + 5 text = dark
green
set regular date control background color to green
 

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

Top