Field colors

[T Miller]

How do you tell a field that if the date is 21 days past it needs to be "a
color"

 

[Rick B]

Us the conditional formatting in your forms or reports and enter the
criteria and the field format you desire.

 

[T Miller]

How do I specify? This is a date and I need it to turn red if it is 21 days
pasts the date?

 

[T Miller]

Nevermind, I have it, geez, if I would just stop rushing....

 

[fredg]

How do I specify? This is a date and I need it to turn red if it is 21 days
pasts the date?

On the form, in design view, select the date field.
Click on Format + Conditional formatting
Set the Condition1 drop-down to
Field Value is
In the next box select
Less Than
in the next text box write:
Date()-21
Select the color.
Click OK.

 

[T Miller]

Thank you sir.
--
Thomas

On the form, in design view, select the date field.
Click on Format + Conditional formatting
Set the Condition1 drop-down to
Field Value is
In the next box select
Less Than
in the next text box write:
Date()-21
Select the color.
Click OK.