[AccessD] Datasheet view selection question

Hey,

I have a form that returns selected results.  The users are wanting to be
able to re-arrange columns, sort on a given column(s), etc.  They then click
on one of several other buttons to be taken to a form related to the
selected record.

I have been using a listview control to display the data.  The users would
pre-select the sort order on zero or more fields from several combo boxes.
But after looking at it, I think we could use a form using a datasheet view.
Playing with it, I am able to move columns, sort, etc.  But one thing they
want is to have the whole line selected when the select a record.  Just as
if you had clicked on the little selection box to the left of each record.

Does anyone know how to select the whole line when one of the fields has
been clicked?

Thanks,
Bobby