473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Coloring rows on a continuous form

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
2 4406
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ron Brennan | last post by:
Good afternoon. The entire task that I'm trying to achieve is to allow a user to browse and upload multiple files simultaneously, hiding the Browse button of <input> tags of type="file" and...
3
by: Greg Neef | last post by:
I need to develop a Tab Form where selecting a particular key from an unbound combo listbox will resulting in the display one or many records from several tables, where each tab has the matching...
15
by: Paul T. Rong | last post by:
Hi everybody, This time a very very difficult case: I have a table "tblStudent", there are 50 students, I also made a form "frmStudent" based on "tblStudent", now if I don't want to show all...
4
by: Laura | last post by:
Here's the situation: I'm trying to use an update query to copy data from one row to another. Here is the situation: I have 5 companies that are linked to each other. I need to show all 5...
4
by: Kathy | last post by:
What is the standard technique for handling the fields in the following scenario on a continuous form? Multiple Divisions. Each Division has multiple Buildings. Each Building has a Supervisor. ...
5
by: Wilfried Mestdagh | last post by:
Hello, I wants to set the background color of rows in a datagridView based on the value of a particular cell. Someone knows how to do this ? -- rgds, Wilfried http://www.mestdagh.biz
5
by: James | last post by:
I have a Continuous form in Access 2000. The form contains a date field and the user has requested( demanded nicely) that they want the date field to be yellow if there is no data in the field....
6
by: dufnobles via AccessMonster.com | last post by:
I have a form that excepts text input from a user. I would like to have the form display the same line several times so that the user can enter several different responses on one form screen. ...
9
by: Patrick A | last post by:
All, I've got a continuous form with one field on it, with a comob
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.