![]() |
Removing Scroll Bars from a Listbox on a Form
I have a simple listbox (M, F), but when I try to reduce its size to just fit
the text both horizontal and vertical scroll bars fill up the box. How do I eliminate them? |
Removing Scroll Bars from a Listbox on a Form
"MikeM" wrote:
I have a simple listbox (M, F), but when I try to reduce its size to just fit the text both horizontal and vertical scroll bars fill up the box. How do I eliminate them? I should have added: can it be done in the Listbox properties window, or does it have to be done in code? |
Removing Scroll Bars from a Listbox on a Form
Try making the ColumnWidths a tad less than the overall with, implicitly if
necessary. For the vertical scroll bar I think that would only appear if the height does not accommodate all the rows. Regards, Peter T "MikeM" wrote in message ... "MikeM" wrote: I have a simple listbox (M, F), but when I try to reduce its size to just fit the text both horizontal and vertical scroll bars fill up the box. How do I eliminate them? I should have added: can it be done in the Listbox properties window, or does it have to be done in code? |
Removing Scroll Bars from a Listbox on a Form
Thanks, Peter. I didn't notice the entry "ColumnWidths" in the Properties
window. It was blank, so I set it to a small number and got rid of the scroll bars! "Peter T" wrote: Try making the ColumnWidths a tad less than the overall with, implicitly if necessary. For the vertical scroll bar I think that would only appear if the height does not accommodate all the rows. Regards, Peter T "MikeM" wrote in message ... "MikeM" wrote: I have a simple listbox (M, F), but when I try to reduce its size to just fit the text both horizontal and vertical scroll bars fill up the box. How do I eliminate them? I should have added: can it be done in the Listbox properties window, or does it have to be done in code? . |
All times are GMT +1. The time now is 06:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com