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

cc0623 (can you share your name?)
This seems like the perfect use of Conditional Formatting of text boxes. You can use "Expression Is" to reference "a specific field". Make sure you understand the difference betwee "202" (string) and 202 (numeric).

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: cc0623@yahoo.com
Date: Mon, 26 Sep 2011 18:29:50 +0000
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?

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

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

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/