Access Tip: Combo Box vs. List Box

When creating forms in Microsoft Access, you can make data entry easier by providing populated lists for certain entries.  Things like product codes, states, and other specific information that is consistently repeated throughout your data. You can only select one item in a combo box.

A combo box provides a drop-down box when the field is entered. That drop-down box will hold the data you set up during form creation. When you are not in the box, the list does not show.

A list box provides a similar option, but takes up more space on your form. A list box will show a certain number of entries on the form, which is useful for short lists, since you can see all the possibilities. You also can scroll if all the entries do not fit in the space allocated.  If you need to be able to select multiple items from a list, you need to use a list box.

For more tips on using Access to become more productive, attend one of our many Microsoft Access classes. We look forward to seeing you soon!

  • Share/Bookmark

Tags:

Leave a Reply