Compound Lookup Field Only Showing First Field

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
Hello Chris.

Chris said:
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,
Click to expand...

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]
 
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]
Click to expand...

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
 
Back
Top