1-866-245-5224 sales@keystonelearning.com

Access 2007: Working with List Boxes

Access 2007: Working with List Boxes

The list box control displays a list of values or choices just like a combo box. However, with a list box, all of the list choices display on the screen at one time.

A nice thing about using a List Box is that a user is forced to choose from one of the List Box entries – there is no option here for typing in a value that doesn’t appear in the list.

Creating list boxes is nearly the same as creating combo boxes.

Creating a List Box for Values You Enter

  1. Open the form in Design View
  3. Choose the List  Box command in the Controls group on the Form Design Tools Design Contextual tab
  5.  Click and drag to draw the List Box on your form

Figure 25. List Box Wizard - Choose List Box Option

    4.     Choose “I will type in the values that I want

    5.     Click Next


Figure 26. List Box Wizard – Type List Values


    6.     Enter the list box values

    7.     Resize the column

    8.     Click Next


Figure 27. List Box Wizard – Remember the Value


    9.     Choose to remember the value for later use

    10. Click Next


Figure 28. List Box Wizard - Create a Name


    11. Enter a Name for your list box

    12. Click Finish

    13. Save the form

    14. View the form in Form View

    15. Test the new List Box


Figure 29. List Box Sample