Conditional Formatting date due color

[Desstro]

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"?

[maximus]

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