Allowing user to sort columns in listbox

[smpil]

I've got a listbox in a form which has 5 columns in it. How do yo
enable the user to sort by column simply by clicking on the column hea
(ascending first click, descending second click)..

Many thanks!
smpi

 

[smpil]

here is a scnshot of the listbox, if that helps

many thanks,
smpi

+----------------------------------------------------------------
| Attachment filename: listbox.jpg
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=114326
+----------------------------------------------------------------

 

[Adrian Jansen]

Teach your users to right-click in any column of the listbox. Brings up a
floating menu with a sort option. Anything else involves adding command
buttons and code to select a column and sort by it. The Windows Explorer
type sort is not available from within Access ( unless its been added to
A2003 ).

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control