How do I insert colors to fill a drop box?

  • Thread starter Thread starter mm
  • Start date Start date
M

mm

I am new to access and I am having a tough time. I have created a drop box in
a field in the datasheet that has three labels that lets me choose different
percentages showing the completion of a statement. How would I be able to
insert colors to fill the check boxes so it shows up in a form or report? I
need the colors yellow, green, and red.
 
Conditional formatting is your friend ;-) You can use it in both forms and
reports (for all versions of Access after - and including - Access 2000).

With a couple of provisos. First, you can't do this if your form is in
datasheet view; you'll need to set up a continuous form that looks like a
datasheet (pretty easy). Second, I assume that you're wanting to do this
for the combobox (drop-down) control, rather than a checkbox (which you
mention later); you can't change the colour of a checkbox.

In design mode, with the combobox selected, choose Conditional Formatting
form the Format menu. For Condition 1, choose Field Values Is in the left
box, then select the condition you want (equals, or perhaps between) in the
next box, and enter the value(s) in the next box(es); then select the
Fill/Back Colour for the condition. Add another two Conditions for the
other conditions you are testing for.

HTH,

Rob
 
Back
Top