Conditional Format?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hello,
Is there a way to use conditional formatting to highlight the lowest or
highest value in a query result in Access 2003?

Jim
 
Jim said:
Is there a way to use conditional formatting to highlight the lowest or
highest value in a query result in Access 2003?
Click to expand...


You can do nothing about how a query's sheet view is
displayed.

OTOH, if you would use a form (even in sheet view) to
display the data, there are several ways to highlight
values.
 
I am using a form to display the data. I want to change the color of the
lowest value shown.
 
Add a text box named txtMin to the form's header section and
set itd control source expression to =Min(thefield).

The set Conditional Formatting for thefield's text box in
the detail section. Use Expression Is: thefield = txtMin
and set the desired color properties.
 
Thanks

Marshall Barton said:
Add a text box named txtMin to the form's header section and
set itd control source expression to =Min(thefield).

The set Conditional Formatting for thefield's text box in
the detail section. Use Expression Is: thefield = txtMin
and set the desired color properties.
--
Marsh
MVP [MS Access]


I am using a form to display the data. I want to change the color of the
lowest value shown.
Click to expand...
Click to expand...
 
Back
Top