Color some values in combo box

[JustinP]

Is it possible to color some of the values in a combo box one color
based on a criteria and others another color?

To be more specific about what I want to do:

Color all the records in the combo box that are redundant, red (i.e.
If Me![Redundant] = Yes)

 

[Guest]

Hi Justin

Use the "conditional formating" option - it's on the Fortmat Menu.

Hope this helps

 

[Douglas J. Steele]

It's not possible.

You could employ Conditional Formatting in a form in Datasheet view, and use
that as a subform to simulate a list box with multiple colours, but that's
about it with the controls available in Access.

There might be 3rd party tools that can do it, but I'm afraid I don't know
of any.

 

[JustinP]

I had a feeling this would be the case.

Thanks for your help.

It's not possible.

You could employ Conditional Formatting in a form in Datasheet view, and use
that as a subform to simulate a list box with multiple colours, but that's
about it with the controls available in Access.

There might be 3rd party tools that can do it, but I'm afraid I don't know
of any.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Is it possible to color some of the values in a combo box one color
based on a criteria and others another color?

To be more specific about what I want to do:

Color all the records in the combo box that are redundant, red (i.e.
If Me![Redundant] = Yes)

 

[William Hindman]

....if you are working with a full installs rather than a runtime, then
Lebans has a solution at http://www.lebans.com/vb_listbox.htm that provides
conditional formatting in a list/combo on a per line basis ...he uses a
control in a wizard to allow this which is why it won't work on a runtime
....hth

William Hindman

 

[JustinP]

This is a database I am sending out to clients with next to no
knowledge of database design. I want them to be able to just open the
..mde and not have to do anything else. Is this going to be a problem
using this solution?

Thanks for you help.

...if you are working with a full installs rather than a runtime, then
Lebans has a solution at http://www.lebans.com/vb_listbox.htm that provides
conditional formatting in a list/combo on a per line basis ...he uses a
control in a wizard to allow this which is why it won't work on a runtime
...hth

William Hindman

Is it possible to color some of the values in a combo box one color
based on a criteria and others another color?

To be more specific about what I want to do:

Color all the records in the combo box that are redundant, red (i.e.
If Me![Redundant] = Yes)

 

[William Hindman]

....sounds just like most clients ...look at the sample lebans provides
....the conditional formatting is set by you, not the user unless you code it
that way ...as long as they have a full install, they won't know the
difference.

William Hindman

This is a database I am sending out to clients with next to no
knowledge of database design. I want them to be able to just open the
.mde and not have to do anything else. Is this going to be a problem
using this solution?

Thanks for you help.

...if you are working with a full installs rather than a runtime, then
Lebans has a solution at http://www.lebans.com/vb_listbox.htm that
provides
conditional formatting in a list/combo on a per line basis ...he uses a
control in a wizard to allow this which is why it won't work on a runtime
...hth

William Hindman

Is it possible to color some of the values in a combo box one color
based on a criteria and others another color?

To be more specific about what I want to do:

Color all the records in the combo box that are redundant, red (i.e.
If Me![Redundant] = Yes)