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)

Hi Justin

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

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"JustinP" wrote:

> 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)
>
>

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
http://I.Am/DougSteele
(no private e-mails, please)


"JustinP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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)
>

I had a feeling this would be the case.

Thanks for your help.


Douglas J. Steele wrote:
> 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
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "JustinP" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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)
> >

....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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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)
>

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.


William Hindman wrote:
> ...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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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)
> >

....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

"JustinP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>
> William Hindman wrote:
>> ...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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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)
>> >
>