Combo List (Access 2003)

Topic

New Reply

Thank you very much Hans for your help. I can’t thank you enough for all the assistance you have given me through the years.
But……………I have another question…..I have a combo box that the user can select a name from – first and last – in separate fields. When they select a name it only shows the first name – how do I get the field to show the first and last name? Thanks again

Reply | Quote

Replies

Although the dropdown list part of a combo box can display multiple columns, the text box part always displays only the first column with non-zero width. So if you want the text box part to display the full name, you must concatenate the first and last names in one field of the Row Source, for example as

[FirstName] & ” ” & [LastName]

or

[LastName] & “, ” & [FirstName]

Reply | Quote