G
Guest
How do you tell a field that if the date is 21 days past it needs to be "a
color"
color"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Us the conditional formatting in your forms or reports and enter the
criteria and the field format you desire.
criteria and the field format you desire.
G
Guest
How do I specify? This is a date and I need it to turn red if it is 21 days
pasts the date?
pasts the date?
G
Guest
Nevermind, I have it, geez, if I would just stop rushing....
F
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.
G
Guest
Thank you sir.
--
Thomas
--
Thomas
fredg said: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.