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

Senin, 26 September 2011

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

Greetings Tiffany,

Table and query datasheets don't support conditional formatting. Creating a datasheet form takes less time than creating and sending an email.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: cc0623@yahoo.com
Date: Mon, 26 Sep 2011 20:52:50 +0000
Subject: [MS_AccessPros] Re: Change color of record based on event???

Hi John,

My name is Tiffany. Thank you for responding to my question. I am assuming this is to be done under forms? Since only two people are using this database the primary party does not wish to add a form to it. Can this be done under datasheet view or design view?

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>