viewing combo box properties

[Young20]

I have a lookup colum in my datasheet. Is there any way that i can change the properties so that I can view both the first name and the last name in the same box once it is chosen. Currently in design view I have a column for first name and a column for the last name. When I choose a name from the lookup column, all it shows is the last name... i would like for it to show both the lastname, firstname.

please advise... thanks

 

[CEH]

Search the forum on "concatinating"..... You should find what you need.

 

[gemma-the-husky]

if your combo box is linked to a query that shows eg

personid, personsurname, personfirstname

then change it a 4-column query so you have the following

personid, personfirstname & " " & personsurname, personsurname, personfirstname

and change the column widths to

0, 0.1, 3, 3

so that the second column is 0.1 wide.

------------------------------------------------
The drop down will display

Jones Robin
Smith Terry
William Michael

but when you select an item the compbo box will show
eg Michael Williams.

the combo box shows the first non-zero width column - in this case the one we set to be FirstName & Surname, although we don't see this in the drop down, because its only 0.1 wide.

don't set it to 0 wide, because the point is that the combo box shows the first NON-ZERO width column.

hope that's what you meant

 

[Young20]

Follow up Question

Thanks! That did what I wanted it to do. Now I have one more question that relates to this. I got it so that the combo box shows the lastname, firstname. Is there any way that i can regress back and when I export the data from that table for it to export it in the form of last name in one cell and first name in another cell?