Sort by clicking Columns in ListView ActiveX?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FDC - 23 Sep 2004 19:35 GMT

Is there no way to find out if a column header was "clicked" so that I can
sort that column in my code? There isn't any event on the control that would
suggest I can. I know I can set in progamatically and in the properties.
But, I'd like to give the user the ability to click a header that would fire
off an event that would allow me to sort that column. Hmmm, any advice?

FRED C

Reply to this Message

Alex Dybenko - 24 Sep 2004 09:14 GMT

You can use ColumnClick event for this
ColumnHeader.Index returns index of clicked colimn

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Is there no way to find out if a column header was "clicked" so that I can
> sort that column in my code? There isn't any event on the control that
[quoted text clipped - 5 lines]
>
> FRED C

Reply to this Message

FDC - 24 Sep 2004 15:49 GMT

That event isn't on the control though. The only events are: On...Updated,
Enter, Exit, Got Focus and Lost Focus. I've been programming with Access
since it was 2.0 but haven't ever used the MS ListView ActiveX Control....it
doesn't let you do much event-wise, does it? Other online sites say that
there is an On Click event for the column too, but I can't find it....

> You can use ColumnClick event for this
> ColumnHeader.Index returns index of clicked colimn
[quoted text clipped - 7 lines]
> >
> > FRED C

Reply to this Message

Alex Dybenko - 25 Sep 2004 07:34 GMT

yes, this is bit tricky
open form's class module
in top lef combo select your listview control
in right combo - desired event proc
access will insert one for you

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> That event isn't on the control though. The only events are:
> On...Updated,
[quoted text clipped - 18 lines]
>> >
>> > FRED C

Reply to this Message