Highlighting a drop-down box

[SHIPP]

I am doing some validation on my form. After checking the various fields for errors I am trying to change the background color to identify which fields have errors. The following works for normal input fields

lngYellow = RGB(255, 255, 0
Me!CommodityID.BackColor = lngYello

However, when I try and use it for a dorp down box Access comes back with an error indicating the property is not supported. Any ideas would be appreciated.

 

[Elwin]

It worked ok for me when i tried it.

Are you looping through the collection of controls on your
form to validate them? Are you sure the error is being
thrown on a combo box, and not a check box or something?

-----Original Message-----
I am doing some validation on my form. After checking the

various fields for errors I am trying to change the
background color to identify which fields have errors. The
following works for normal input fields.

lngYellow = RGB(255, 255, 0)
Me!CommodityID.BackColor = lngYellow

However, when I try and use it for a dorp down box Access

comes back with an error indicating the property is not
supported. Any ideas would be appreciated.