List and Combo boxes

[Stand]

Can someone please describe, in simple terms, what the difference is
between List and Combo boxes and when/why you would choose one over the
other?

Thanks... Stand

 

[Klatuu]

A List Box is a control that allows you to display data from a table, a
query, or a list of options entered in the Value List Property. A List Box
displays as many rows as will fit in the list box. You can scroll throught
the entries. It also allows you to select a single item or multiple items
form the list. You cannot enter any data in a list box manually. To add
items to a list box, you have to do it with VBA.

A Combo Box gets its name from the fact that it is a combination of a text
box and a list box. There are some differences. A Combo Box shows only one
row. You can make it drop down to show the number of rows defined in the
List Rows property. You can make only one selection from a Combo Box. You
can scroll and select with the mouse or you can begin typing in a Comb Box
and it will change to show the closest match if you have the Auto Expand
property set to Yes. You may also add new items to a list using VBA.

Use an unbound Combo Box to seach for a specific value in a field and
navigate to the selected record. Use a bound Combo Box for a control where
you want only certain values to be accepted for that control.

Use a List Box when you want multiple rows to always be visible or if you
need to allow the user to select multiple items.

In reality, you can use either at your own descriction depending on how you
want your user interface to work.