[AccessD] Access 2007 Query Line Coloring

The data returned might be the result of SQL statements, but Queries are automatically 
displayed using a Datasheet object when opened with Docmd.Openquery. so I'd  assume 
that is what David means.

Unfrotunately, you can't apply conditional formatting to rows in a Datasheet object, so the 
answer is still - you can't do that.  

The best you can do is apply a multi-format to individual columns using their Format 
properties - but that only lets you differentiate between +ve, -ve, 0 and Null.  

-- 
Stuart

On 5 Mar 2013 at 10:26, Charlotte Foust wrote:

> Queries are the result of SQL statements.  I don't know of any SQL commands
> that would allow you to do that.  Datasheets have more properties, and you
> might want to display the results in a datasheet.
> 
> Charlotte
> 
> On Tue, Mar 5, 2013 at 6:42 AM, David A Gibson <
> davidalangibson2010 at gmail.com> wrote:
> 
> > 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
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>