Have textbox change color to identify an upcoming deadline

  • Thread starter Thread starter Nancy
  • Start date Start date
N

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?
 
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?
Click to expand...

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.
 
Back
Top