Show Text Instead of IDs in Access Combo Boxes

In this Microsoft Access tutorial, you'll learn how to adjust combo boxes to display text values instead of ID numbers, ensuring your forms present user-friendly information. By following this guide, you'll be able to make combo box configurations using queries and format them correctly for a seamless user experience.

Cooper from Loveland, Ohio (a Platinum Member) asks: I created a combo box in my Microsoft Access form to let users select a customer name. The combo box pulls data from a table of customers, which includes IDs and names. For example, the table lists 1 - Kirk, 2 - Spock, and 3 - Bones. However, when I select a name in the combo box it displays the ID (like 1, 2, or 3) instead of the name (Kirk, Spock, or Bones). How can I adjust the combo box so that the names are displayed instead of the IDs?

Prerequisites

• Relationships
• Relational Combo

Links

• Invoicing
• Calculated Fields

Recommended Courses

• Access Beginner 2
• Access Expert 1

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, Display Text Instead of ID in Combo Box, Microsoft Access Combo Box Fix, Relational Combo Box, Access Bound Column, Access Key Column, Access Combo Box Wizard, Access Query for Combo Box, Access Combo Box Properties, Combo Box Data Source, Access Format Combo Box, Access Column Width