[AccessD] Access 2007 Query Line Coloring

David,

One approach might be to use a derived column in the query to create an "eye-catcher".

Here is an example.  The derived column called "EyeCatcher" is filled with a value of
"<<===" if the Age field is less than 22. 


EyeCatcher: Switch([Age]<22,"<<===")


This is probably not as good as a color, but it does provide an easy way to spot specific values in a query.

Brad

PS.  Here is the actual SQL from a little test. 

SELECT Table1.Age, Switch([Age]<22,"<<===") AS EyeCatcher FROM Table1;






-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of David A Gibson
Sent: Tue 3/5/2013 8:42 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Access 2007 Query Line Coloring
 
I have an output (Select) query that I would like to highlight (in red,
yellow, or something) any of the lines where the age of the individual is
<22.  I didn't see any options that would provide that capability.  Could do
that in a report but wanted to see if anyone had done something similar in a
query.

David Gibson

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.