I have a listbox based on a query that is filtered by a selection in a combobox. The combobox represents employee names and the listbox lists their tasks after updating the combobox. This works fine.

My question is this:

Sometimes a task is not completed by it's due date. Since listboxes are very unforgiving in the formatting aspect I was wondering if it is possible to create a field in the underlying query that will display, say, and exclamation point to let people know that this task is past the due date (TaskDue in the query).

Thanks for any help!

I guess you could set up a column in the listbox with could show a "*" if you will with code like:

iif(now()> [DueDate], "*","")

The column could be set in a prominent location that shows the * next to those task that are over the due date and just blank for those on schedule.

Steve

That worked perfectly. Is there any way to make the overdue character a different color?

Thanks for the help!

I don't believe so . . .

One of my 'wish list' would be to have the option to 'right' justify currency . . . in a column.

But the standard list box is just that . . . standard!

Steve