Compound Lookup Field Only Showing First Field

[Chris]

Hello,

I am using a lookup field for name and the name is broken into two
fields - FirstName and LastName. When selecting the name from the
drop down, I see both first and last names, but after selecting, I
only see the first name. For visual reasons, I would like to see the
first and last names in the form. I am using Access 2007, but believe
this issue is in previous versions as well.

I am open to suggestions and appreciate your help,

Chris

 

[Wolfgang Kais]

Hello Chris.

I am using a lookup field for name and the name is broken into two
fields - FirstName and LastName. When selecting the name from the
drop down, I see both first and last names, but after selecting, I
only see the first name. For visual reasons, I would like to see
the first and last names in the form. I am using Access 2007, but
believe this issue is in previous versions as well.

I am open to suggestions and appreciate your help,

This is not an issue, it's by design. When the list isn't displayed,
you will only see the first column of the query, whose column width
is greater than zero.
Instead of the first name, use a calculated field in the underlying
query that returns the concatenated name:
[FirstName] & " " & [LastName]

 

[Chris]

This is not an issue, it's by design. When the list isn't displayed,
you will only see the first column of the query, whose column width
is greater than zero.
Instead of the first name, use a calculated field in the underlying
query that returns the concatenated name:
[FirstName] & " " & [LastName]

Thanks for the prompt response Wolfgang. This got me really close and
just required some 'tweaking' to get the sorting and other minor
features taken care of.

Thanks again for your help!

Chris