Setting widths in a listbox

A

Akilah

I have a listbox with 9 columns, I can set the width of all but the ninth
column. I've set it in the property box and through VBA, but it never stays
set. On the form, it goes way beyond the set width. How can I fix it?

Thanks
 
D

Douglas J. Steele

What have you got for the ColumnWidths property and for the ListWidth
property?
 
A

Akilah

I have lstActiveUsers.ColumnWidths = "1 in;0.5 in;1.5 in;1 in;2 in;1 in;1
in;1 in;1 in;" but I don't have anything for ListWidths
 
S

Steve

There's no Listwidth property for a listbox!!

Maybe you should advise the OP to expand the listbox to 30 columns since you
think that is not so outrageous. He could very well have a legitimate
reason!

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
D

Douglas J. Steele

You're right: I misread your question, and thought you were dealing with a
combo box.

Afraid I don't have a suggestion for a list box.
 
Top