tr******@comcast.net wrote in news:e76bb624-f8e7-4ed0-ad3f-
29**********@i76g2000hsf.googlegroups.com:
I have a subform being displayed as a continuous form. One of the
fields for each record is a combo box with two options- removal or
installation. How do I color all the fields for the row based upon
this combo box selection?
For instance, I want to color the entire row a light green when
"installation" is chosen and a light red when "removal" is chosen.
Thanks in advance for the help.
Troy Lee
This works in Access 2000 and more recent.
Open the form in design view.
Multi-select all the controls. Select Format->Conditional Format ...
in the menubar.
set the background color in the default Formatting to light green.
Set the background color light red.
set the Condition 1 combo to Expression is.
Set the expression to [combo box] = "removal"
Change combo box to the real name of your combobox.
save. Test.
--
Bob Quintal
PA is y I've altered my email address.
** Posted from
http://www.teranews.com **