• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1056
  • Last Modified:

Conditional formatting in listbox items in MS Access

In the attached Access application, reference the form frmPatient. There is a listbox in the bottom right called lstUnprintedRecs. As you are adding new patients (whose records have not been printed), they are populated in the listbox. The purpose of the listbox is to allow the user to quickly reference all unprinted records (patients) by clicking on the list item & navigating to that particular record. Once item is printed, it is deleted from that listbox. All that works.

I would like to be able to color code (to indicate criticality) the listed items in the listbox as I add them. For e.g, when I add a new record (patient), I should be able to specify criticality of patient by selecting either Red, Blue, Green (via another combox box or radio buttons). Hence, when the patient name appears in the listbox as a listed item, it has the background of the specific color? As different patients/records/items are added, each listed item should have the background color specified for it. I doubt this is possible, but thought I'd ask.

0
datasolutionz
Asked:
datasolutionz
  • 4
  • 3
  • 2
  • +1
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
AFAIK ... this is the only (pricey) 3rd party product that will do that:

http://www.dbi-tech.com/ComponentPage_ctList.aspx

The good news is ... you about 50 some controls for the price.

Your other option is to use a datasheet subform instead of list box (make it look like a list box) ... and then apply Conditional Formatting to do this.

mx
0
 
datasolutionzAuthor Commented:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Lebans has some stuff that might be useful, but IIRC the colored listbox was never fully complete (and Stepen doesn't do this anymore):

http://www.lebans.com/List_Combo.htm

That said, the suggestion by MX is probably your best bet, and the easiest to implement and maintain throughout Access versions.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Not sure why the db is attached ?

mx
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<Not sure why the db is attached ?>

I believe it's because the author wrote "In the attached Access application" and then forgot to attach it.
0
 
datasolutionzAuthor Commented:
I have implemented a subForm to achieve what I needed. Thanks for everyone's attention
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The it would seem you'd accept Databasemx's comment here:

http:#a34894404

Where he wrote:

"Your other option is to use a datasheet subform instead of list box "

Which is EXACTLY what you did.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I object to any deletion, as noted by LSMConsulting ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
opps wrong button
0
 
_alias99Commented:
All,
 
Following an 'Objection' by DatabaseMX (at http://www.experts-exchange.com/Q_26836706.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Experts.
 
At this point I am going to re-start the auto-close procedure.
 
Thank you,
 
_alias99
Community Support Moderator
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now