Senin, 26 September 2011

RE: [MS_AccessPros] Change color of record based on event???

 

Dear cc0623, (name?)

Use Conditional Formatting. Select all the controls that you want to be purple,
then click on Conditional Formatting. In 2003 and earlier, it's on the Format
menu. In 2007 and later, it's on the Design tab under Font. Choose Expression
Is, then enter your field name in brackets, an equals sign, and "202", then
select either the Fill/Back Color or Font/Fore Color to set the color you want.

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: Monday, September 26, 2011 8:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Change color of record based on event???

I would like to change the color of the record based on data.

I want to change the color of the record to purple if the data in a specific
field says "202". So in datasheet view I will see specific records are purple
and someone else can followup with that record.

I am a newbies to access and I am having difficulty with this. Can anyone
adivise me please?

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

Yahoo! Groups Links

__._,_.___
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