Drop down list box colour

Thanks Jeff, I will have a look and see. I really appreciate your help!

"Jeff Boyce" wrote:

> I am not aware of a way within Access, but you might want to visit Stephen
> Lebans' website to see if he's done something like this...
>
> http://www.lebans.com/
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Billiam" <Billiam RemoveThis @discussions.microsoft.com> wrote in message
> news:1A24D224-312C-41FA-9B19-863D393B4AAF@microsoft.com...
> >I have a bound drop down list box which displays 7 set choices: Active,
> > Interim, On Leave, suspended, de-certifed, resigned and deceased. I would
> > like to add colour to some of the choices, so the items are noticed more
> > easily (ie the colour red is the background to the choice Suspended, the
> > colour green is the background to the choice Active).
> > Can this be done within the same drop down list box?
> > Billiam
>
>
>

It does not appear to me that Stephen Lebans has done this...oh well!

"Jeff Boyce" wrote:

> I am not aware of a way within Access, but you might want to visit Stephen
> Lebans' website to see if he's done something like this...
>
> http://www.lebans.com/
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Billiam" <Billiam DeleteThis @discussions.microsoft.com> wrote in message
> news:1A24D224-312C-41FA-9B19-863D393B4AAF@microsoft.com...
> >I have a bound drop down list box which displays 7 set choices: Active,
> > Interim, On Leave, suspended, de-certifed, resigned and deceased. I would
> > like to add colour to some of the choices, so the items are noticed more
> > easily (ie the colour red is the background to the choice Suspended, the
> > colour green is the background to the choice Active).
> > Can this be done within the same drop down list box?
> > Billiam
>
>
>

No, not with the built-in ACCESS combobox control.

--

Ken Snell
<MS ACCESS MVP>


"Billiam" <Billiam DeleteThis @discussions.microsoft.com> wrote in message
news:1A24D224-312C-41FA-9B19-863D393B4AAF@microsoft.com...
>I have a bound drop down list box which displays 7 set choices: Active,
> Interim, On Leave, suspended, de-certifed, resigned and deceased. I would
> like to add colour to some of the choices, so the items are noticed more
> easily (ie the colour red is the background to the choice Suspended, the
> colour green is the background to the choice Active).
> Can this be done within the same drop down list box?
> Billiam

Thank you for taking the time to respond, Ken. I really appreciate it.

"Ken Snell (MVP)" wrote:

> No, not with the built-in ACCESS combobox control.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
> "Billiam" <Billiam.RemoveThis@discussions.microsoft.com> wrote in message
> news:1A24D224-312C-41FA-9B19-863D393B4AAF@microsoft.com...
> >I have a bound drop down list box which displays 7 set choices: Active,
> > Interim, On Leave, suspended, de-certifed, resigned and deceased. I would
> > like to add colour to some of the choices, so the items are noticed more
> > easily (ie the colour red is the background to the choice Suspended, the
> > colour green is the background to the choice Active).
> > Can this be done within the same drop down list box?
> > Billiam
>
>
>

How about using a subform with conditional formatting?

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




Billiam wrote:
> I have a bound drop down list box which displays 7 set choices: Active,
> Interim, On Leave, suspended, de-certifed, resigned and deceased. I would
> like to add colour to some of the choices, so the items are noticed more
> easily (ie the colour red is the background to the choice Suspended, the
> colour green is the background to the choice Active).
> Can this be done within the same drop down list box?
> Billiam

I am so sorry, Crystal, I did not receive notification of your reply...

I am afraid I am fairly new to all this, so bear with me
please...........................okay pretty please???

So if I make a seperate lookup/reference table, (Active, Suspended etc) base
a form on it and drop it on my main form that would work? As to the
conditional formatting, I do not know how to proceed--here is my best guess
(you can LOL if you like!:

I would add a conditional expression to the Validation Rule property of the
table
=IIf([Active] = "Yes", "Active (somehow add a hex value???ie green" "Active
somehow greyed out"
and somehow nest the other Status' in more IIf statements?????
"strive4peace" wrote:

I really do not know what to do, Crystal, any advice as to an examle posted
anywhere???

> How about using a subform with conditional formatting?
>
> Warm Regards,
> Crystal
>
> remote programming and training
>
> Access Basics
> 8-part free tutorial that covers essentials in Access
> http://www.AccessMVP.com/strive4peace
>
> *
> (: have an awesome day
> *
>
>
>
>
> Billiam wrote:
> > I have a bound drop down list box which displays 7 set choices: Active,
> > Interim, On Leave, suspended, de-certifed, resigned and deceased. I would
> > like to add colour to some of the choices, so the items are noticed more
> > easily (ie the colour red is the background to the choice Suspended, the
> > colour green is the background to the choice Active).
> > Can this be done within the same drop down list box?
> > Billiam
>