Solved

Conditional formatting list box/query

Posted on 2003-11-05
5
213 Views
Last Modified: 2012-06-22
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
0
Comment
Question by:calcutec
  • 2
5 Comments
 
LVL 4

Expert Comment

by:ki_ki
ID: 9688850
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
 

Author Comment

by:calcutec
ID: 9690240
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
 
LVL 4

Accepted Solution

by:
ki_ki earned 50 total points
ID: 9690635
As i said, I don't have time either to look at it. But the asterix trick is a goog idea.
0
 
LVL 32

Expert Comment

by:jadedata
ID: 10022623
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

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question