Combo Box Colours

[ptaylor-west]

Can I designate colours for each option in a combo box as you can with a Yes/No box, for example : Urgent in Red, Chase in Blue, Normal in Green, Non-Urgent in Orange and anything manually entered in default Black

 

[accesswatch]

I don't think you can do this but it would be very nice.

A possible work round is to use a label or text box outside the combo box and change caption and background colour of the label using code fromcombo box on onclick event. The downside is that this only works for the currrent row.

If you are trying to find an easy way to identify different categories of records then the method I tend to use is to filter the option box for the different categories. I use an option box to select the category and then through code build a new rowsource for the combo and then apply the filter. I also use an addional button to display all records.

Neither of these are as apealing as your 'vision' though but they may be of use.
Hope this helps
Regards
Trevor from ww.accesswatch.co.uk

 

[ptaylor-west]

Thanks for the info, what I was trying to do was to catch the users eye by highlighting fields on the form..............never mind it may be one development for Microsoft for the future,

Many thanks once again