Change color of drop down menu on current record only

  • Thread starter Thread starter Ben
  • Start date Start date
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
 
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
 
Back
Top