Column Widths Property

[bpitche]

How do you change the .ColumnWidths property for a list box using VB. I am using one list box, but the RowSource is changing as a different option button is selected. I know it should be:

Forms!frmEquipment!lstLISTBOX.ColumnWidths = ?

I am just not sure how to put the widths in so it will accept it. If anyone can help me, I would appreciate it.

Thank you, Brad Pitcher
The Hoover Company
bpitcher@hoover.com

 

[jebry]

Hi Brad!

You have to put the column widths in as a string:

"100;0;120"

will set the widths of three columns. The default measurment is in twips so if you want to use another you will need to include cm for centimeters or in for inches:

"1 in;0;6 in"

hth
Jeff Bridgham

 

[bpitche]

Thank you Jebry!! Brad Pitcher
The Hoover Company
bpitcher@hoover.com