Combo Box - Select Field versus Populating Field

[EddieN1]

I have a combo box where the Bound field is CustNbr. When the dropdown is selected, I want to list a LookupName, and DisplayName with CustNbr in the first column (with a width of zero so it doesn't show). If the operator starts entering letters, I want the list to automatically change position based on entered letters in LookupName column. However, after the selection is made, I want the DisplayName to appear in the combo box. Any Suggestions?

[June7]

Don't think that is possible. Have a textbox show the DisplayName with an expression that references the combobox column index. Index begins with 0.

=[comboboxname].[Column](2)

[EddieN1]

I figured out a way to do this. Set up Column Widths to 0";0";2" as a default. On Enter, change it to 0";2";2". On Exit, change it back to 0";0";2". However, since I can't say... Me.CustName.ColumnWidths = "0";2";2"" (the compiler throws up with all the quote marks), I dimmed a string named, say, strWid and set it to...
"0" & Chr(34) & ";2" & Chr(34) & ";2" & Chr(34)
and then said... Me.CustName.ColumnWidths = strWid. The Chr(34) are double quotes.

[June7]

I should have said 'not possible without VBA code'. Glad you found a solution.

"0"";2"";2""" might work

Also, not including the " might work because when in Design view, Access will provide the inch symbol (") if forgotten, although might not in runtime.