Setting widths in a listbox

[Guest]

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

 

[Douglas J. Steele]

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

 

[Guest]

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

 

[Douglas J. Steele]

Try setting the ListWidth property to 10 in.

 

[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
(e-mail address removed)

 

[John Marshall, MVP]

steve please get back on your medication.

John... Visio MVP

 

[Guest]

I tried but I got the message "Method or data member not found"

 

[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.