Originally posted by johncameron
do you mean a combo-box? If not do you mean you want to change the colour of a listbox by the selected item?
No combobox. An actual listbox control in which I set the rowsource through code. I have managed to change the color of the selected record but I want to set the color of a row in a listbox according to a certain value of that row.
Originally posted by xander
I had a similar issue and used a continuous form that was designed to look like a list box - use conditional formatting to get the colours you need.
I now that trick but do not want to use that because then I have to develop a form with a lot of events for every listbox i wish to use. Now I can use a generic form with the listbox and include that form as subform in my actual form. All properties, sorting and rowsources I can add by code.