I have a form with 3 List Boxes on it. One of these list boxes has 3 columns of which I would like to either have the entire line or one of the columns seperately display different colors.
I have read through many posts so I am familiar with the fact that this can not be done with a list box directly.
I was hoping for something without having to resort to either a 3rd party control or building an atom bomb to squash an ant. I have looked at the control at http://www.lebans.com
but I would prefer to stick to standard controls if possible.
My first thought was to hide one column that I do not have any events triggered out of and use a subform to display the information on top of the hidden column and hopefully that way I could use the conditional formatting thing to individually set up the colors of the lines in the one column.
Maybe it is because I have not dealt much with subforms but initially Access 2000 complained you could not have a subform on a form set to continuous so I set the main form to single view and was planning to set the subform to continuous so I could use it but I do not see anywhere I can do that and the conditional formatting is greyed out if I try selecting the subform and choosing it.
The column I want to color is text, and all I want to do is change the background color of each record in that column individually....What a hassle this has been for something that seems so simple on the surface...
Hope you all can come up with a solutions out there.