Lowest value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a continous form with values sorted by date. I want to highlight
the lowest value in the list. Any ideas?
 
Ernst said:
I have a continous form with values sorted by date. I want to highlight
the lowest value in the list.
Click to expand...

What list?

If you what to highlight the text box with the lowest value
in the form's record source table/query, then add a text box
(named txtLowest) to the form's Header section and set its
control source expression to =Min(thefieldname)

Assuming the text box you want to highlight is named
txtField, select the text box and use the Format -
Conditional Formatting menu item. In the CF window, select
the Field Value Is option, Equal to and enter txtLowest in
the Value box.
 
Back
Top