Background or font colors in forms

[gtford]

I have a "to do" task list which includes a due date for completion of the task. I want to design the form so that when it's opened any past due tasks are emphasized by either a red background or red fonts (whichever is easiest). There's probably a simple way to do this, but I sure haven't been able to figure it out.

Any help would be appreciated. Thanks.

 

[Jerry Stoner]

In the forms current event:
If Me.YourControlName < Date() Then
Me.YourControlName.ForeColor = 255
End If
HTH

 

[David R]

Also if you're using Access 2k or later there is Conditional Formatting available (probably does the same thing behind the scenes, but it's better organized).