troubleshooting Question

Change display text in lookup column

Avatar of bjv211
bjv211 asked on
Microsoft Access
2 Comments1 Solution866 ViewsLast Modified:
I have a lookup field in Access 2007 which shows Lname, Fname in the combo box and stores ID.  How do I change the format of the displayed text once an option is chosen?  I want to dispaly Lname, Fname in the selected Column.  As you can see in the image, only Lname is displayed once it's selected.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros