I am trying to make the value in a date textbox turn red if certain criteria exists. Here is my code but it is not turning red. I have this in the onformet event of the detail section of the report.
If Me.txtFinApprovalDueDate < Now() And Me.txtFinApprovalRecdDate = "" Then
Me.txtFinApprovalDueDate.ForeColor = vbRed
What is wrong with this?