Listbox Columns

[Gsurfdude]

Hello,

I have a listbox on a form that holds about 53 columns. How do I
"progammatically" fit each column width to the width of the data coming in
with out manually setting them in the COlumnWidths property?

Currently I have the ColumnWidths property the looks like this:
0.2";0.3";0.2";0.6";0.35";0.4";0.4";2.6";0.2";0.15";3.4 .......

I hope this makes sense.

Thank you.

 

[Alex Dybenko]

Hi,
have a look here:
http://www.lebans.com/listboxcolumnresize.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Gsurfdude]

It worked like a champ! Thank you. One more question, in the Columnheadings
property how can I get them to be vertical rather than horizontal?

 

[Douglas J. Steele]

If there's not a solution at that same site http://www.lebans.com/toc.htm
then it's likely not possible. <g>

 

[Douglas J. Steele]

Can you possibly use a subform rather than a list box?