List Boxes and Combo Boxes

Diving Line


If you need to print this page out, type your name in the box below.

Your Name : 


Information

If you have to enter the same data again and again into a form, it can be quicker and easier to have a list of data that you can choose from.  Using a list of data to choose from also make your data entry more accurate.

There are two types of lists you can create ...

  • A lookup list (where you select an item from the list)
  • A combo box (where you can either type into the box or select an item from the list)


Information
Creating a List Box

A list box will give you a list of options to choose from.

Open the form in Design View Database.

Right-click on the field you want to add the list to and select Change to  and List Box from the pop-up menu.

Databases


Right-click on the field again and this time click on the Properties option on the pop-up menu.

Databases

In the properties window, change the Row Source Type to Value List.

In the Row Source option, type in the values you want in your list.  Each value needs to be inside a set of quote marks " " and separated by a ; like this Databases .


Databases


Change back to Form View Databases to enter and view the data.

Databases


Information
Creating a Combo Box

A combo box gives you a list of options you can use to enter data as well as the ability to type into the field.

To create a combo box, open the form in Design View  Databaes .

Right-click on the field and select Change To and then Combo Box from the pop-up menu.

Databases

Right-click on the field again and select the Properties option.

Databases

In the properties window, change the Row Source Type to Value List.

In the Row Source option, type in the values you want in your list.  Each value needs to be inside a set of quote marks " " and separated by a like this Databases .

Databases

Change back to Form View Databases to enter and view the data.


Databases


PrintIT  Print out this Page

Next  Sharing Data Between Tables


Last modified: Monday, 7 December 2020, 3:06 PM