backcolor of a Field based on condition Yes or No in another field

  • Thread starter Thread starter Gene C
  • Start date Start date
G

Gene C

I need to change the back color of a field when the check box is selected in
another field.

If HOLD is checked as Yes then I need Search backcolor to be red.
 
Gene,
What version of Access are you using?
If Access 2000 or above, use Format/Conditional Formatting to handle
that.

Expression is [Hold] = True

Can be used to control the backcolor of [Search]
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top