combo box visible fields

[mark_jm via AccessMonster.com]

Does any one know if it is possible to set the properties of a combo box to
display more than just the first non zero width field when the column list is
closed?

This one is flumuxing me a little

Thanks

Mark

 

[Allen Browne]

The combo can show only one column when it's not dropped down.

However, you can concatenate values together into one column, e.g.
SELECT ClientID, [Surname] & ", " & [FirstName] AS FullName
FROM ClientID
ORDER BY Surname, FirstName, ClientID;