By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,200 Members | 1,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,200 IT Pros & Developers. It's quick & easy.

Coloring rows on a continuous form

P: n/a
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
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Mon, 19 May 2008 05:49:30 -0700 (PDT), tr******@comcast.net wrote:

Check out the "Conditional 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
"installation" is chosen and a light red when "removal" is chosen.

Thanks in advance for the help.

Troy Lee
Jun 27 '08 #2

P: n/a
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 **
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.