Combo Box Size Question

[ProgEval]

I have a combo box that has two columns. One is the number that gets entered and goes into the database. The second is the text that defines the number, which is used just for clarity and reference for the data entry person.

Due to space issues I would like the size of the combo box to be just wide enough for the number in the first column. Although, is there a way for if the drop down is clicked the options automatically expand to the right to show the text in the second column.

I hope this makes sense. Any help would greatly be appreciated.

 

[realstandman]

You can go to the properties of the combo box and have the number column be the bound column and you can specify the widths of the other colums. That will expand them when you use the drop down.

Don't think and the solution will come.