Here's our Microsoft Office Tip for.. November 29, 1999
Click Here to see a complete list of all of our previously released Tips!
Hiding Columns In A Combo Box
There isn't an obvious property for hiding a column in a multi-column combo or list box. If you're using the Column Count property--Stop! Instead, use the Column Width property. Specifically, to hide a column, use the setting 0". For instance, to hide the first and fourth columns in a four-column box, use the Column Width property 0";1";1";0". This setting will hide the first and last column and display the second and third column in 1-inch columns. Fortunately, you can alter the widths of the displayed columns without affecting the hidden columns.