
Originally Posted by
amrut
The color in VBA should be Long and not the HEX. With the Combo Box selected in design view, go to the VBA Editor window, Click F4 to bring up the properties window if it is not open. See the BackColor property and the color code associated with it.
Ex.
Code:
Me.Combo0.BackColor = 13017476
Teal green corresponds to 9732411 in the VBA editor, property sheet. I tried the following line:
Code:
=[Me].[Combo53].[BackColor]=9732411
and received an error message stating "The object doesn't contain the Automation object 'Me.'.
Then I tried:
Code:
=[Combo53].[BackColor]=9732411
and nothing happened. I also tried single and double quotes around 9732411 and still nothing.