Change color of drop down menu on current record only

B

Ben

I have entered the code correctly to change the background color of a drop
down menu. Unfortunately, the entire drop down menu is that color now and
when I go to the next record that color is constant on that field. I have
entered the same code to change the color on the OnCurrent Event, but not
sure why the color is not going back to "white" when i go to a new record.

Please help
 
M

Marshall Barton

Ben said:
I have entered the code correctly to change the background color of a drop
down menu. Unfortunately, the entire drop down menu is that color now and
when I go to the next record that color is constant on that field. I have
entered the same code to change the color on the OnCurrent Event, but not
sure why the color is not going back to "white" when i go to a new record.
Click to expand...


When you change a property setting, it statys that way until
you either change it again or close the form. Your current
event procedure has to set the color or set it to white:

If something Then
Me.combo.BackColor = somecolor
Else
Me.combo.BackColor = vbWhite
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble color coding drop down selection 3
Windows 7 Default page color for e-mail (Outlook) 1
Color a drop down list 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Combo Box in 2007 changes other combo box background 4
Change the font color/background of a text box depending on value 6
Conditional formatting 3
Access How to record date/time when specific field is modified in Access 2007 0

Top