Access 2013 - Selecting a Color from a Dropdown

Question

I have a scenario where records are classified by color: Red, White or Blue... At the moment I am having the users enter a number and correlating that number to a color. I would really like the users to be able to select the classification from a dropdown where they just see color blocks and then display a color swatch for the selected classification.

Is this something Access can do?

Thanks.

J

---

http://digitalcamel.blogspot.com/

Answer 1

Hi J. Perhaps not as a combobox but probably with a continuous form, you can. Just a thought...

Answer 2

Hi J

In my opinion, maybe the slider control is the better choose, you could have threw slider controls(min 0, max 255) and add a label to show the current color, then user just need to change the slider to change the color, in the On Updated event, get these controls values and based on them to set the label color.

If there are just few colors and are classification, as BD said that you could use continuous form. You also could have multiple dropdown controls (e.g. one for category, the other for the colors of that category)

Regards

Starain

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.