Hi All,
I want a listbox with column sort buttons at the top and adjustable
column widths. You see them in all kinds of applications, like Windows
Explore's file list. I could build one for myself using labels with button
down and button up events and a bunch of code to round it out. Isn't there
something simple already out there that I can drop in?
Thanks for any pointers,
Max
Damon Heron - 06 May 2008 00:29 GMT
How about a subform as datasheet? You can adjust the columns, sort by
column (simply right-click) and with a little coding make a selection from
the datasheet row.
Damon
> Hi All,
>
[quoted text clipped - 8 lines]
> Thanks for any pointers,
> Max
MikeB - 06 May 2008 00:41 GMT
> Hi All,
>
> I want a listbox with column sort buttons at the top and adjustable
> column widths. You see them in all kinds of applications, like Windows
Those are ListViews. Access Controls > Additional controls(elipsis)>
Microsoft ListView Control, ver 6.0
> Explore's file list. I could build one for myself using labels with button
> down and button up events and a bunch of code to round it out. Isn't there
> something simple already out there that I can drop in?
>
> Thanks for any pointers,
> Max
Max Moor - 07 May 2008 21:05 GMT
> Those are ListViews. Access Controls > Additional controls(elipsis)>
> Microsoft ListView Control, ver 6.0
Hi Mike,
I was afraid of that. I've put off trying to implement them, as I've
heard so many complains. I bit the bullet and started in on it, and just
about have it all working for me, though. So far it's not bad at all. We'll
see what happens when I try to get fancy some day.
Regards,
Max
Albert D. Kallal - 06 May 2008 01:14 GMT
I find so often that users really don't need the column sizing....
And, the few cases for sorting, I add a combo box at the top of the form.
And, you do get filter by selection for free if you copy the menu buttons.
Here is some screen shots of continues forms I used, and I tend to like them
better then datasheet viewes...
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Signature
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
Stephen Lebans - 06 May 2008 12:01 GMT
An alternative to a form in Datasheet view is here:
http://www.lebans.com/listboxcolumnresize.htm
ListBoxColumnResize.zip is a Class that allows the user to resize the
ColumnWidths of a ListBox at Runtime.Also supports an Autosizing method for
the ColumnWidths.
Version 2.2 April 27/2002
Modified Columns AutoSizing method to work with both ListBox and Combo
controls.

Signature
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
> Hi All,
>
[quoted text clipped - 8 lines]
> Thanks for any pointers,
> Max