Access 2016 Intermediate

Access 2016

Lesson 11 – Using Advanced Form Design

Steps

Practice Data

3. Edit the list, if necessary. The text appears in the list.

Type Red

4. Select OK .

Click

The Edit List Items dialog box closes.

Notice that when you click on the arrow in the Color field, the new option has been added to the list.

C REATING A L IST B OX



Discussion

You can create a list box on a form. A list box provides you with a list of values from which you can choose. Choosing from a list is much faster and more accurate than remembering a value to be typed. However, unlike a combo box, you can only choose an item from the list; values not present on the list cannot be entered into the table.

A list box can be bound to a field, meaning that when you select or enter a value, the value is entered into a field in the corresponding table. A list box can also be unbound, meaning that when you select or enter a value, it is held in memory to be used in another control or calculation.

The List Box Wizard guides you through the process of creating a list box. Select the list of values from an existing table or query, or create the values for the list yourself. If you choose to select the list from an existing table or query, the wizard prompts you to enter the table or query and the field name. If you choose to create the list of values yourself, the wizard displays a column for the entries. Either way, after the values are entered in the wizard, specify whether the values should be entered in a field in the table or held in memory for later use.

When you use the List Box button, the mouse pointer changes into a copy of the tool with a plus sign (+) above and to the left of it. The center of the plus sign (+) indicates the position of the top left corner of the list box.

OFFICEPRO, Inc.

Page 201