List Box types

  • Thread starter Thread starter DGW
  • Start date Start date
D

DGW

How can i get a ListBox with the gray column headings that once clicked,
sorts the list respectfully? common object seen everywhere but my
applications. I've looked through ActiveX's and tried Technet and MSKB to no
avail.

Any direction would be appreciated. Thanks

Darryl
 
DGW said:
How can i get a ListBox with the gray column headings that once
clicked, sorts the list respectfully? common object seen everywhere
but my applications. I've looked through ActiveX's and tried Technet
and MSKB to no avail.

Any direction would be appreciated. Thanks

Darryl
Click to expand...

It's easy enough to do just by putting labels as headers above the list
box, sized to match the columns, and using code in the labels' Click
events to change the ORDER BY clause in the list box's rowsource query.
 
DGW said:
Have done that. But am looking for the resize function, too.
Click to expand...

I'm not sure what you mean. Are you talking about dynamically resizing
the columns by dragging the lines between them? That would be difficut
to do with a list box. You may want to use a datasheet subform instead,
if you don't need multiselect ability, or else look for an ActiveX
control that works with Access.
 
The OP might want to look at this:
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.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Stephen Lebans said:
The OP might want to look at this:
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.
Click to expand...

Oooh, aaaah. ;-)
 
Thanks but not quite what i'm looking for. your "clean" code gave me some
great ideas though.

I had looked through all the ActiveX's but didn't find it there, either.
I'll probably need to buy it somewhere.

Thanks again.

Gratefully yours,
Darryl

Happy New Year!
 
Back
Top