This is message is being posted for code evaluation/correction to a problem
for which a partial solution was provided by "Klatuu". Any insight from
the
"MVPs" or anyone with a solution will be greatly appreciated. I am not a
code
expert so a simple suggestion/solution specific to the solution will be
most
useful.
The code below changes the background color of a drop down menu choices
when
placed in the After Update code section. However, the last two colors,
“Blue”
and Orange” have a black text that shows trough the color background.
Why?
Me.Combo56.BackColor = IIf(IsNull(Me.Combo56.Value) = True, 15066597,
Switch(Me.Combo56.Value = "Green", 65280, Me.Combo56.Value = "Yellow",
65535,
Me.Combo56.Value = "Red", 255, Me.Combo56.Value = "Blue", 16737843,
Me.Combo56.Value = "Orange", 5220351))
|
