Changing listbox columnwidth at runtime

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Gwen said:
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.
Click to expand...


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

Marshall Barton said:
All runtime form dimensions are specified in twips (1440 per
inch). Use that as a conversion factor when you construct
the ColumnWidths string.
Click to expand...
 
Thank you very much!

Stephen Lebans said:
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.
Click to expand...
 
Back
Top