Highlighting a drop-down box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
Click to expand...
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
Click to expand...
comes back with an error indicating the property is not
supported. Any ideas would be appreciated.
 
Back
Top