>>I used the DataCombo from MS Data List component to display a
>>list of column item from a Table.
>>
>>I only can specific a column to list, as shown below.
>>Can I list more than one columns?
>>
>> dcTypeItem.ListField = "ItemColumn1"
>
>If you want to continue to use this control, you have to concatenate fields in your SQL query (select firstname + ' ' + lastname as ItemColumns1 ...).
>
>You can also use the combo box from the Forms components library (Add Microsoft Forms from Project -> Components).

If I would use the concatenate method. How could I expand the pull-down
list's width to allow all the FirstName and LastName be able to display
in the list(it is too long to fit into the list combo)?
As the list only limit to its Combo control width and I have a space
limit in my form. Any control Property to set to automatically expand
according to its list items' width? Thanks.