Coloring rows on a continuous form

[troy_lee@comcast.net]

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
"installati on" is chosen and a light red when "removal" is chosen.

Thanks in advance for the help.

Troy Lee

[Tom van Stiphout]

Re: Coloring rows on a continuous form

On Mon, 19 May 2008 05:49:30 -0700 (PDT), troy_lee@comcas t.net wrote:

Check out the "Conditiona l Formatting" topic in the help file.
-Tom.

>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
>"installatio n" is chosen and a light red when "removal" is chosen.
>
>Thanks in advance for the help.
>
>Troy Lee

[Bob Quintal]

Re: Coloring rows on a continuous form

troy_lee@comcas t.net wrote in news:e76bb624-f8e7-4ed0-ad3f-
297a2408339b@i7 6g2000hsf.googl egroups.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
"installati on" 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 **