February 3, 2006 at 6:34 am
I had an application once, where I was able to change the color of the line in a drop down list of combo box based on a color value in the row. I don't remember how I did it. Has anybody done this? Perhaps it was an early version of Access and the ablity has been lost.
Thanks for any info,
Steve
February 3, 2006 at 10:37 am
In which Access version?
February 3, 2006 at 11:28 am
Access 2003
February 3, 2006 at 12:09 pm
like alternating colors or just the textfield above in the combobox?
Access2000 and higher implement conditional formatting:
February 3, 2006 at 1:05 pm
That's close but not quite what I want to do. I have a drop down where row 1 is active and should be in black and row 2 is inactive and should be in red and three is active and in black. It is the forecolor that should change based on the value of the row in the drop down. In Access 2003.
Steve
February 4, 2006 at 6:20 am
The following links have a colorlistbox using a subform to implement the coloring
http://www.candace-tripp.com/pages/access_downloads.aspx
http://www.candace-tripp.com/download/colorlistbox.zip
Otherwise I would think it was a custom control.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply