Combo Box Displays Full Name and Initials but only records the initials in combo box

[JGrots]

Is there a way to have the drop down list from the combo box display an employee's full name and initials but only record the initials in the combo box. For example, the drop down list would look like this:

Doe, John | JD
Smith, Joe | JS


Williams, Dana | DW

So if I want Joe Smith, I would click on his name and in the combo box once I'm done selecting his name, JS would appear, not his full name.

[June7]

Use concatenation.

You have fields for Initials, FirstName, LastName? or do you calculate the initials from the name fields (that's what I would do).

Why do you want the initials? Are you using them as key value? Risk multiple employees with same initials.

[orange]

What happens when Don Watson, Jane Simpson and/or Joan Davidson show up?

[JGrots]

I wanted to have initials because of the lack of space to show the full name in the box. But you guys bring up good points. I think I'll make it so the full name shows instead.

[orange]

What you show/display on a form or combo and what you store in your table(s) are quite different things.

[JGrots]

Instead of displaying the initials, I want to display an employee's First and Last name and their department they work in. Right now I have two tables, Employee table and a department table. I have these two linked tables linked together using Primary and Foreign keys. I have a combo box for the employee and I want to display the employee's name and their department. The problem I'm having is that the name shows up but the department shows up with the ID number and not the name. The department is linked to the employee table by the DepartmentID number. Can this be done?

[June7]

The combobox RowSource will have to be a query that joins the employee and department tables. This will allow the related info such as department name to be available for display in combobox.