Conditional formatting list box/query

I have an unbound list box on a form that is populated by a
query.  The query returns records of information about
healthcare facilities; each record is a facility name (and
key) and a set of four dates representing essentially the
last updates of different sets of facility related data.
Users select a facility in the list box and from there
navigate to related forms for the selected facility.  

I want to apply conditional formatting to these dates, such
that they appear red when a certain time threshold is
exceeded.  On a similar report, for example, I apply
conditional formatting using the Datediff function, but
this is easy on a form.  It seems that to do it in the list
box I have to apply formatting somehow within the sql of
the query that populates it.  Is it possible to embed
conditional logic (and the datediff function) in a jet sql
query?  Or am I going to have to redesign the way the list
box is populated with a vba procedure that would allow me
greater control over fields?  

Thanks in advance,

J.D.
Novice access developer
calcutecAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ki_kiCommented:
Hi calcutec,
Sometime ago I posted a list/box question. Somoene suggested the link below. I never really had time to check it out. Let me know if it worked for you:
http://www.lebans.com/listboxenhanced.htm
0
calcutecAuthor Commented:
Thanks ki_ki,

That is a little more code than I have time to sift through right now, especially in a language I don't really know.  But it does show that at least some custom formatting is possible in a list box.  Looks like it manipulates entire rows, not fields, which is what I need.

Another group offered the solution of using sql to append an asterisk to overdue dates, which looks at this point like what I'll have to do.

Thanks again.
0
ki_kiCommented:
As i said, I don't have time either to look at it. But the asterix trick is a goog idea.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jadedataMS Access Systems CreatorCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: ki_ki {http:#9688850}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jadedata
EE Cleanup Volunteer
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.