seeker said:
I have a continuous form that lists invoices with the most recent at the top
and first field highlited. I would like the whole record highlited and have
the most recent at the bottom of the continuous forms.
To get the records to appear in sorted order (e.g. oldest at
the top to newest at the bottom), change the form's record
source to a query that sorts the date/time field in
descending order.
To use a hightlight color based on a data value, you have to
have a way of identifying the data value so you can use
Conditional Formatting (Format menu) to color a text box.
In your case, the lateast date/time value can be identified
by using a text box (named txtMostRecent) with an expression
like =Max(datetimefield) in the form's header or footer
section. Then add a text box to the detail section, make it
the same size as the detail section and use the Send to Back
(Format menu) to put it behind all the other controls. In
the CF window set the Expression Is option's expression to
[datetimefield] = [txtMostRecent]
and select your favorite backcolor. You may also want to
set the BackStyle of your other text boxes and/or labels to
Transparent.
