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?

"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?

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?

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?


.