Changing width of combo-box automatically

  • Thread starter Thread starter John
  • Start date Start date
J

John

I've got a combo box listing a cost centre number with the cost centre
description. When you search for the cost centre number in the drop down
list, the description is hidden and you have to scroll sideways to view -
can I make it so it automatically expands the width of the combo-box so I
can see the cost centre number AND the description. I don't really want to
expand the whole box in design view because I end up with a lot of blank
white space.

TIA
 
Open the form in design view
Right click on the combo box and select properties
Select the format tab
There is a property named ColumnWidths with the size in
inches of each column (i.e. 0.52";2.5") and a Property
named ListWidth. Adjust the size to get the view you
want. Make sure the ListWidth totals the two
ColumnWidths or you will have to scroll to see both
columns.
 
Back
Top