Reminder dates in listbox

[Delerna]

As stated, it is not possible to produce the desired effect in a list box.
By desired I mean

I would like the dates that are within 5 days of expiring to show in red text

But there is always more than 1 way to skin a cat.

How about something like this........... just as an idea.
[code=sql]
SELECT qryTrackingDate .[Employee ID],
qryTrackingDate .[Trace Date],
DateDiff("d",Da te(),[Trace Date]) as DaysRemaining,
qryTrackingDate .ELastName,
qryTrackingDate .EFirstName
FROM qryTrackingDate
WHERE (((qryTrackingD ate.[Trace Date])>Date()))
ORDER BY qryTrackingDate .[Trace Date];
[/code]

Now the user can see how many days are remaining.
Not quite the same as highlighted red, but still effective


PS
I for one appreciate NeoPa's efforts and certainly do not see that he is bashing you. It really is difficult to get motivated to help someone when they don't even format posted code in a way that makes it readable.
Just take his Good advice onboard for future posts
Thanks Neopa

[tuxalot]

Thanks Delerna for your post. Your solution achieves the desired effect.

Tux

[ChipR]

Just curious, but is there any reason to use a listbox over a subform?

[tuxalot]

No reason Chip, and from your prior post and what I am learning a sub-form may be a more appropriate way to do this. This db was created by another and I'm modifying it and learning Access along the way. I'm reading more about how to replace the listbox with a subform and apply conditional formatting as you mentioned previously.

Thanks for the reply,

Tux

[NeoPa]

Thanks NeoPa

Thanks Delerna. I appreciate the support :)

Tux,

Although we've all been trying to respond directly to your original question, I think that Chip's ideas are probably more appropriate as a solution for you in the longer term. Well worth your while getting some experience in that area too I would say. You'll probably enjoy the extra scope.

[tuxalot]

Thanks NeoPa. I'll educate myself a bit here and call in when I get stuck.

Tux

[Delerna]

I also think the subform is probably the superior option. My post was more about thinking "outside the square"

[tuxalot]

It's very nice to have options.