A2003 ListBox: can't resize columns

[bulrush]

I have Access 2003 on Win XP.

I am using a ListBox control on a form. I can create multiple columns but cannot resize the columns. My data source is a value list, populated via VB code. Is there any way I can let my users resize columns? Data may be too large to fit with the preprogrammed column widths.

Thanks.

 

[HiTechCoach]

I do not know of any way to do this with VBA code. For example, you can not use the mouse to drag the column widths.

Some way you will need to ask for each of the column widths that use VBA code to set the property for the list box.

You might also consider writing the the data to a table and use a sub form in datasheet mode. This woulf allow the users change column widths with the mouse.