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

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.
 
A

Al Campagna

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Form BackColor in VB 1
Access Trying to change the color of a Combo text field in forms access 2010 0
Background color based on condition 2
change label format based on control it is attached to 2
Itemselected backcolor in listbox 1
run a code based on the field conditional formatting back color 3
BackColor 11
Conditional formatting of detail section in an access form 2

Top