Have textbox change color to identify an upcoming deadline

[Nancy]

Annually, I have a report that must be completed by our vendors. On my
Vendor form, I have a text box that highlights when the report is due i.e.
January 01, 2009. My form is F_Vendors, the Form is sourced by a query,
Q_Vendors. I would like for the text box on the form and/or report to
highlight to a different color thirty days prior to the due date. I.e.
December 01, 2008. This would give the user a reminder that we have a report
due and to submit the request to the vendor. When the report is completed, I
would like the textbox to default back to the normal color of the form. Any
ideas?

 

[John W. Vinson]

Annually, I have a report that must be completed by our vendors. On my
Vendor form, I have a text box that highlights when the report is due i.e.
January 01, 2009. My form is F_Vendors, the Form is sourced by a query,
Q_Vendors. I would like for the text box on the form and/or report to
highlight to a different color thirty days prior to the due date. I.e.
December 01, 2008. This would give the user a reminder that we have a report
due and to submit the request to the vendor. When the report is completed, I
would like the textbox to default back to the normal color of the form. Any
ideas?

Use "Conditional Formatting". Select the textbox in report design view; on the
menu select Format... Conditional Formatting.

Put a criterion on the field of

<= DateAdd("m", 1, Date())

and choose a background color (yellow or red say) to highlight the field.