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
|
|||
|
|||
Changing background color in a dropdown box based on value in box
I am building a project database for my team and we need to use 3 status
levels in order to inform management quickly about project status. The statuss are Red, Yellow and Green. I want to be able to put these 3 items in a dropdown in my project database and have the background of the dropdown box itself change to that color. So if someone could explain the steps to take for that I would most appreciate it... also if you can provide a little insight on how I would use the same control to update the entire page to that color from the dropdown box. Thanks |
#2
|
|||
|
|||
Changing background color in a dropdown box based on value in box
In a form or report, you can use conditional formatting (CF) to color the
combo. In design view, select the combo, and choose Conditional Formatting on the Format menu. You can use the 3 conditons to get the 3 colors (as well as perhaps white if the combo is blank.) Not sure what you meant about coloring the entire 'page.' A report page? The 2-k page buffer? The page of a tab control? -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Ry" wrote in message ... I am building a project database for my team and we need to use 3 status levels in order to inform management quickly about project status. The statuss are Red, Yellow and Green. I want to be able to put these 3 items in a dropdown in my project database and have the background of the dropdown box itself change to that color. So if someone could explain the steps to take for that I would most appreciate it... also if you can provide a little insight on how I would use the same control to update the entire page to that color from the dropdown box. Thanks |
Thread Tools | |
Display Modes | |
|
|