I have a "datedue" in a form.
How do I set the conditional formatting for the date text to be a certain color if the current system date is 45 days before or greater than the "datedue"?
I have a "datedue" in a form.
How do I set the conditional formatting for the date text to be a certain color if the current system date is 45 days before or greater than the "datedue"?
Use Conditional Formatting:
I have a date Field: [Dt]
Due Date is Calculated by:
=Date()-[Dt] this is the Control source of an unbound TextBox on my form.
For Conditional Formating of this unbound Text box I enter the expression [Dt]>=45 and then select the font color from the option below.
if this solves your problem mark the thread solved