Kamis, 20 Oktober 2011

Re: [MS_AccessPros] Color labels

 

No, I just want it to apply to the Department column and any field within that column the term "pumper run a" is turn that field into a specific color.  I have it doing this but not if there is any other text with that field.
 
 
So "Pumper Run A" turns color, but not "Pumper Run A Lead".
 

Tiffany Atchley
PO Box 1003
Fort Duchesne, UT 84026
435-722-7833
WWW.ODYSSEYMINISHETLANDS.NET

________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, October 20, 2011 8:20 AM
Subject: RE: [MS_AccessPros] Color labels

 
Tiffany-

Do you want the color to appear for all the columns (fields) if Department =
"Pumper Run A"?? If so, apply the same Conditional Formatting rule to every
control where you want that to happen.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
Sent: Thursday, October 20, 2011 4:10 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Color labels

How do I create the rule?

I created a rule that states: Expresssion is [Department]= pumper run a and then
the background color. It works fine but I want it to be all inclusive. So,
anything in that column with the term "pumper run a" within the field will turn
that color.

I have Pumper Run A Lead, Foreman, etc in that column.

Thanks, Tiffany

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar