changing colour of text when date is <=date() (1 Viewer)

[timbo343]

Hi All

how do i change the colour of text in fields in forms when a date is <=date(). So when a date is selected from a drop down calendar, if the date selected is todays date then it turns the rest of the text on the form blue and if the date is less than todays date (before) then it turns it red? This is for over due jobs and current jobs. Ive tried Conditional formatting but conditional formatting is greyed out

Private Sub Due_Date_Updated(Code As Integer)
What goes in this part???
End Sub


Please help

Tim

 

[Smart]

REchanging colour of text when date is <=date()

Private Sub Due_Date_Updated(Code As Integer)
What goes in this part???
End Sub

This may be long winded but...
if the date selected is <= Date () then
formfield1.backcolor = 167711680
formfield2.backcolor = 167711680
etc
else
formfield1.backcolor = 255
formfield2.backcolor = 255
etc
end if