Change Row Color In List view Control Under Certain Circumstances

I have a database that contains a list of wanted persons,  On the search form the search results are displayed on an access list box control. As I understand it the row color can not be independently controlled. One of the fields contain the classification of the offence, Misd or Felony, what we need is if the offence has a felony classification is for the background of the row to be red otherwise remain white. I am using Ms Access 2003. Is there a different control or a newer version of Access that will do what we need?.
mickeyshelley1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Nick67Commented:
No version of Access supports that in a ListBox.
Replace the Listbox with a continuous subform or rework the search results form to be a continuous form.
That will support conditional formatting of each row.
A ListBox never will.
PatHartmanCommented:
I would use the continuous subform recommended by Nick but you could use the ListView control which has a lot of formatting options not available in a ListBox.  However, be warned, the ListView may no longer be available as of A2013.
Dale FyeOwner, Developing Solutions LLCCommented:
you might also want to look at Steve Leban's enhanced listbox code.  Steve has been out of the Access business for quite a while, but did some really great things for the community when he was engaged. Have not tested any of this since the 2003 version, but if that is a functionality you want and desire, give it a look.
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

mickeyshelley1Author Commented:
Thanks for the responses, i am actively looking into the recommendation i will post back....
Helen FeddemaCommented:
Can't do this with a listbox, but you can certainly colorize rows in a datasheet subform using conditional formatting.  See my Access Archon #201:

http://www.helenfeddema.com/Files/accarch201.zip

Here is a screen shot of the form:

Colorizing datasheet rows
If you need an action for a selected row or cell, just add a DblClick event to the appropriate cell.

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
mickeyshelley1Author Commented:
Than you so sorry for the delay
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.