Creating and editing list controls in Access 2007 is easier than ever!
A Value List row source populates a list control (list box or combo box) with items that don't occur naturally in the data. When creating a Value List list control in Access 2003 and earlier, you must separate the items with a semicolon. That's not a big deal, but it can be tedious, especially if the list is long. Access 2007 makes the process a bit easier:
- After inserting a list control, choose Value List as the control's Row Source Type.
- Click the Builder button in the Row Source field to launch the Edit List Items dialog box.
- Type an item and press [Enter]. Continue until you've entered all of the list items.
- Click OK.
The new dialog box is easier to work with and you can easily set a default value for the list control, but there's more. It's much easier to edit this list while using the control. In Form View, Access 2007 displays a small icon below the list control -- simply click it to launch the Edit List Items dialog box (shown above) and add or delete items on the fly!