Possible to use different backcolors for each option in combbox list?

[avivit]

Hi,

I have a combo-box with two values: Y and N (yes/no).
I'd like to do something which maybe is not possible.
Basically the idea is to make the "y" bold somehow (if chosen), so
will be easy to see which records has "y" in this field.

So I need either of the following:
1. Change the backcolor of this field in records where the value is "y".
2. Have a different backcolor for each option (even while opening the combo list).

In the first place I preferred to use the "check box", but the problem is that when checking one field, or unchecking, changes all the fields in all other records as well (either all r checked or not), and of course, that is not what I need.

Thanks,
Avivit

 

[Frink]

Hallo,

The following FAQs in the Access Other topics Forum may be of some help.

How to highlight the selected record in a continuous form?
How do I get different coloured text for records?
How do I get different background colours for records?

- Frink

 

[BillPower]

If you are using Access 2000+ then:

I've just posted something similar to this in thread705-483828, you can download a demo called frantic.zip at:

http://www.wpower.fsbusiness.co.uk/

This app shows how to change a control's Backcolor and Forecolor based on whether a Check Box is True or False, you can also set the Font Weight if you want.

Let me know if this is what you want or you need any help with it.

Bill