Changing listbox columnwidth at runtime

[Guest]

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
Gwen

 

[Stephen Lebans]

The Columnwidth property, at runtime, is expressed in TWIPS. There are 1440
TWIPS per inch.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Marshall Barton]

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.

All runtime form dimensions are specified in twips (1440 per
inch). Use that as a conversion factor when you construct
the ColumnWidths string.

 

[Guest]

Thank you very much.

All runtime form dimensions are specified in twips (1440 per
inch). Use that as a conversion factor when you construct
the ColumnWidths string.

 

[Guest]

Thank you very much!

The Columnwidth property, at runtime, is expressed in TWIPS. There are 1440
TWIPS per inch.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.