Marty Brittain
Last Activity: Feb 21 '11, 06:37 PM
Joined: Feb 21 '11
Location:
-
The listbox contains items is a To Do list. Each item has a different duedate. All items in the list must be shown. -
Want to highlight tasks in a listbox that are overdue
I have an Access form with a listbox that contains a column with DueDate. I want all of the rows that are past the Due Date to be highlighted in vbRed.
The code that I have tried is this:
If Me.cm_todo_lst. Column(3) < Date Then
Me.cm_todo_lst. ForeColor = vbRed
Else
Me.cm_todo_lst. ForeColor = vbBlack
End If
Thanks in advance.
No activity results to display
Leave a comment: