G
Guest
I have a form with a subform in "CONTINUOUS" view. I want the data in the
date control on the subform to be RED if the date is past, else it should be
black.
What is currently happening is that IF the first form in the "continuous"
subform has a past date, then the color of the dates on the other
"continuous" forms on the subform display properly. BUT IF the first
continuous form in the subform is null or contains a date in the future, the
continuous forms on the subform do not change color even though the date has
passed.
This is the code I'm using:
If Me!Exp.Value < Now() Then
Me!Exp.ForeColor = 255
Else
Me!Exp.ForeColor = 0
End If
date control on the subform to be RED if the date is past, else it should be
black.
What is currently happening is that IF the first form in the "continuous"
subform has a past date, then the color of the dates on the other
"continuous" forms on the subform display properly. BUT IF the first
continuous form in the subform is null or contains a date in the future, the
continuous forms on the subform do not change color even though the date has
passed.
This is the code I'm using:
If Me!Exp.Value < Now() Then
Me!Exp.ForeColor = 255
Else
Me!Exp.ForeColor = 0
End If
