tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Access: Display column headings in a combo box in Access 2010

See solution in other versions of Access:

Question: On an Access 2010 form, I've created a combo box whose values are populated by a query. I want to see the column headings so that I can differentiate between the various columns. How do I display the column headings in a combo box?

Answer: Even though you can only bind the combo box to one column, it is possible to display multiple columns when you click on a combo box. This is often useful when one field in a result set is not enough to differentiate between the different records. For example, you may have multiple suppliers called IBM, but each IBM supplier is uniquely identified by its address.

To display the column headings in a combo box, open your form in design view. Right-click on the combo box and select Properties from the popup menu.

Microsoft Access

On the combo box, there is a Property called "Column Heads". You will need to set this property to "Yes" on the combo box object.

Microsoft Access

You should now see the column headings (Company Name and Address) when selecting the combo box. See below:

Microsoft Access