If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Drop down list box colour
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 |
#3
|
|||
|
|||
Drop down list box colour
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 |
#4
|
|||
|
|||
Drop down list box colour
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 |
#5
|
|||
|
|||
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" 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 |
#6
|
|||
|
|||
Drop down list box colour
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 |
#7
|
|||
|
|||
Drop down list box colour
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 |
#8
|
|||
|
|||
Drop down list box colour
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 |
#9
|
|||
|
|||
Drop down list box colour
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 |
#10
|
|||
|
|||
Drop down list box colour
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 |
Thread Tools | |
Display Modes | |
|
|