|
||||||
|
Last Name, First By Richard Rost 3 years ago Display LastName, FirstName in Combo Boxes Do you know how combo boxes will only show ONE field when the box is closed. If you have first name and last name for a customer and you want to see them both in the box when it's closed, you have to know this trick. Olivia from Newark, New Jersey (a Gold Member) asks: I want to make a combo box to select a customer, but the box will only show first name OR last name when it's closed, not both. How can I see them both together? Also, I've got a bunch of Smiths and even a few John Smiths. How can I tell them apart when selecting? MembersI'll show you how to add a Company Name to the mix. This way you'll see Company (Last, First) and we'll deal with all of the combinations of missing data.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today! LinksString Concatenation: https://599cd.com/Concatenation
|
||||
| |||
Keywords: TechHelp Access first name, last name, last first, display of combo box, multiple values, columns shown, full name, combine first and last, concatenate, together, concatenation PermaLink Last Name, First in Microsoft Access |