Hi all,
I'm trying to get a field turn into red if the date that is in the field is today.
I'm trying to do this in a subform that is set as datasheet view.
Any help would really be apreciated.
Greetings.
Hi all,
I'm trying to get a field turn into red if the date that is in the field is today.
I'm trying to do this in a subform that is set as datasheet view.
Any help would really be apreciated.
Greetings.
Open up the Form in Design View.
Highlight the field you want to apply the Conditional Formatting to.
Right-click and select Conditional Formatting.
Under Condition 1, enter/select:
Field Value Is equal to Date()
Choose your formatting color
Click OK.
Hi JoeM,
Thanks it worked really nice, silly of me no to see this :-(
Greetings.
No worries! Glad it worked out for you!