Combo box:info in drop down list appears different in box once selected. Why? Fix?

[SomeGuy]

I have one combo box which is being used to represent employees last, first, and middle names (to reduce data entry errors).
When I set up the combo box, I designed it to show the last name, then the first name, and then the middle name.

However, when the name is selected from the drop down list, only the last name appears in the box. Why doesn't it show the whole name in the box as it appears in the drop down list?

On a similar note of the combo box drop down list, how can I get the last and first names to be separated by a comma instead of the staight line and no line between the first and the middle?

Any help would be appreciated.

 

[Abby N]

Hello. The reason you're only seeing the last name after the item is selected is the combo and the last name are each 1 field. You can view multiple fields in your list but only one can be placed into the control. What you need to do is combine the first, middle, and last names into a single field. Then set the combo-boxes source to that. This can be easily accomplished with a query. Something like:

FullName: [LastName] & ", " & [FirstName] & " " & [MiddleName]

You can then use the combo box wizard to set up your box. I'm not yet fully caffeinated, so I can only hope I've made myself clear and that this helps.

~Abby

[This message has been edited by Abby N (edited 09-27-2000).]

 

[SomeGuy]

Thanks Abby N. I'll give that a try. =+}