Combo Box: Display Multiple Columns after Selection

Fellow Forum-ers,

How can I make a combo box that will display multiple columns both during and after selection?

I've seen suggestions for concatenation such as:

SELECT  tblNames.FName+' '+tblNames.MI+' '+tblNames.Lname, tblNames.idName
FROM tblNames ORDER BY [LName];

and the same line replacing + with & to account for the problem of null values.

All the variations I've tried have had one or more of the following results:

1. A single-row appearing in response to clicking on the combo boxes down-arrow
2. No text visible in combo box row(s) (although row highlighting and occasional data entry errors did occur).
3. Data from only one column appearing at either the left or right extreme of the combo box.

Any suggestions would be greatly appreciated.

Jason