Drop down list box colour

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" wrote in message
...
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 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" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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

Hi Billiam (is that your name?)

in the design view of the form (you can do it in Form view but I feel it
is best to make design changes in design view):

click on the control

from the menu, choose Format, Conditional Formatting

for instance:
Expression Is -- [Active] = True
-- set Foreground Color, background color, Bold, Italic, Underline,
and/or enabled

~~~
for information on making a subform, read this:

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


Warm Regards,
Crystal

*
(: have an awesome day
*




Billiam wrote:
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

Hi Crystal,

"strive4peace" wrote:

Hi Billiam (is that your name?)

It's a nickname ...Bill+William=Billiam

I would just like to thank you sincerely for taking the time to help....I
have learned so much reading through these forums, and I find your resonses
extremely illuminating! So please except my sincerest thanks for taking the
time to help all of us newbies out--YOU ARE AWESOME!!!

I am going to give this a try on Monday so will let you know how I do!
Have a great weekend!

Billiam


in the design view of the form (you can do it in Form view but I feel it
is best to make design changes in design view):

click on the control

from the menu, choose Format, Conditional Formatting

for instance:
Expression Is -- [Active] = True
-- set Foreground Color, background color, Bold, Italic, Underline,
and/or enabled

~~~
for information on making a subform, read this:

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


Warm Regards,
Crystal

*
(: have an awesome day
*




Billiam wrote:
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