Conditional Formatting Not Working

lundi 27 avril 2015

I hate a field that displays a date on a form.
I set the conditional formatting to be
Value is Between Date() and Date() + 14

It would only apply the formatting for dates that were equal to the date and +5 days.

I then tried Between Now() and Now() + 14
Same results

I then tried Between Date() and DateAdd("d",14,Date())
No change

I checked the property for the box and the back style is normal.

I am making the back color a light red. I tried to change the fore color red. Nothing.

I displayed what Date() was giving me in a text box control and I displayed what Date() + 14 was giving me in a text box control. They both were showing the correct dates, but my date, which was in between them, was not changing colors.

Any ideas?
Conditional Formatting Not Working

0 commentaires:

Enregistrer un commentaire

Labels