Conditional Formatting

  • Thread starter Thread starter Dudley Wright
  • Start date Start date
D

Dudley Wright

Using Access 2002, I would like to apply conditional formatting to a
date control in a form, so that when the date (it is a due date) is 5
days past due, a color is applied to the control. Is this possible?
Thanks
Dudley
 
Dudley said:
Using Access 2002, I would like to apply conditional formatting to a
date control in a form, so that when the date (it is a due date) is 5
days past due, a color is applied to the control. Is this possible?
Thanks
Dudley
Click to expand...

Select the DueDate control.
Click on Format + Conditional Formatting
Set the Condition1 drop-down to
Expression Is
In the text control alongside the drop-down write:
[DueDate] + 5 <= Date()

Set the color wanted.
Click OK.
 
Thanks Fred, works perfectly.

fredg said:
Dudley said:
Using Access 2002, I would like to apply conditional formatting to a
date control in a form, so that when the date (it is a due date) is 5
days past due, a color is applied to the control. Is this possible?
Thanks
Dudley
Click to expand...

Select the DueDate control.
Click on Format + Conditional Formatting
Set the Condition1 drop-down to
Expression Is
In the text control alongside the drop-down write:
[DueDate] + 5 <= Date()

Set the color wanted.
Click OK.
Click to expand...
 
Back
Top