Setting widths in a listbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Akilah - 20 Jul 2007 14:30 GMT

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

Reply to this Message

Douglas J. Steele - 20 Jul 2007 14:41 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>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

Reply to this Message

Akilah - 20 Jul 2007 21:02 GMT

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

> What have you got for the ColumnWidths property and for the ListWidth
> property?
[quoted text clipped - 5 lines]
> >
> > Thanks

Reply to this Message

Douglas J. Steele - 20 Jul 2007 23:28 GMT

Try setting the ListWidth property to 10 in.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>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
[quoted text clipped - 9 lines]
>> >
>> > Thanks

Reply to this Message

Steve - 21 Jul 2007 01:58 GMT

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
resource@pcdatasheet.com

> Try setting the ListWidth property to 10 in.
>
[quoted text clipped - 12 lines]
>>> >
>>> > Thanks

Reply to this Message

John Marshall, MVP - 21 Jul 2007 08:58 GMT

steve please get back on your medication.

John... Visio MVP

> 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

Reply to this Message

Akilah - 31 Jul 2007 19:46 GMT

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

> Try setting the ListWidth property to 10 in.
>
[quoted text clipped - 11 lines]
> >> >
> >> > Thanks

Reply to this Message

Douglas J. Steele - 31 Jul 2007 20:42 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I tried but I got the message "Method or data member not found"
>
[quoted text clipped - 16 lines]
>> >> >
>> >> > Thanks

Reply to this Message