This sample shows how to automatically resize a listbox's column-widths and, while at it, adjust command-buttons (that were created in order to serve as column-headers) as well. The command-buttons implement an ORDER BY-functionality which will re-sort the listbox's contents at the matter of a mouse-click and a single line of code. This is an A97-MDB but can easily be converted into later versions.
This is one of the older entries that can also be found on the original Access-site.
Download: adjustableListboxColumns_97.zip (28.81 kb)
Location: SinglePost