Resize ListBox Columns

[amerfeld]

Hi Everyone:
Just wondering if there's an easy way in Access 2000 to resize listbox columns if necessary to show all information - like you can in a table by clicking, or by the columns autoformatting. Thanks for your help.

 

[freakazeud]

Hi,
check this out:
Resize column at runtime
HTH
Good luck

 

[amerfeld]

Wonderful! Thanks so much. That gives great options. Now I just need to decide which to use. I appreciate the help.

 

[freakazeud]

You're welcome.
Glad I could assist.
Good luck on future projects!

 

[Millah]

Here is another way to accomplish this, but at runtime. This will auto resize the columns when you set the record set of the list box.

http://www.mistahmilla.com/2011/10/resizing-columns-in-ms-access-list-boxes/