Format

[Dante1980]

Hi Guys,

I'm trying to use Conditional Formatting Options on a Text box called "Date". I'd like that this box become Red if its value is between value1 from Text box "Start Date" and value2 from Text box "End Date" or Green otherwise (in this way the color change dynamically every time I change the values of Text Boxes "Start Date " and "End Date"). How can I do that? What I need to type in the Conditional Formatting Windows?

Is there any other way to do that without using Conditional Formatting?

Thanks a lot for you help!!!!

Ciao Ciao

 

[ansentry]

Is you form a "Single" or "Continious"?

Text box called "Date".

You should not use the word "Date" to name anything in access, it is a reserved word.