Changing listbox columnwidth at runtime

[gdev]

Hi,

I have 6 comboboxes. The user wants to be able to sort/filter in any combination with these comboboxes.
I have decided to change the rowsource(query) after each combobox update.
All of my data is displayed is a listbox.
My first problem is I can't seem to get the listbox columnwidth to change after an update.
Listbox.Columncount works perfectly. However, Access seems to be entering its own very small columnwidth sizes.

Please help.

Thanks
gdev

 

[RoyVidar]

They probably work in Twips. Set something manually, then do a Debug.Print of it.

One of mine, with 2 columns and 1.217cm;5cm turns up as 690;2835

Knowing then that there are 1440 twips per inch and 567 twips per centimer should make it possible to work with it.

Roy-Vidar

 

[stix4t2]

gdev,

Me.List0.ColumnWidths = "1.5in;1.3in"

You can specify in whatever unit of measure you prefer. The above example is using inches, or you can use Roy's twips if you omit the unit. Replace list0 with the name of your listbox.

 

[gdev]

Wonderful People, Thanks!