combo box

[le888]

Hi,

Does existe a command that auto expanded the width of a column of a combox? I have try something like this...

Me.cmbBook.(col)2.Width ......But, is the rest of the code?

Thanks,

Le

 

[boblarson]

This should work for you:

    Me.cboYourComboBoxName.ColumnWidths = ".5 in;2.5 in;.75 in"

Just include the number of values for the columns you have. Also, you can specify "0 in" or just put a semi-colon for the zero (such as ";2.5 in;.75 in").

You can substitute your own regional values for the "in" part.