Creating and Formatting Value Lists
One of the most convenient ways to speed up data entry and eliminate mistakes is with value lists. You can format a field to display a pop-up menu, pop-up list, radio buttons, or check boxes. These formats strategically narrow your users' choices, since they present only those options that you consider valid actions. Once a value list is created, it's available for every field in your database, and even to external related files. For example, if you have several fields that will contain a Yes/No, you only have to create one Y/N value list.
Choosing a value list style
The value list style you choose should match the type of data you want to present. Styles are more than aesthetic or arbitrary choices. They affect how long it takes users to figure out what they should do next, and how easily they can do it. Choosing the wrong format negates the efficiency of creating a value list and leads to mistakes.
Radio buttons
Use radio buttons when the choices you offer are both mutually exclusive and limited. For example, a radio button format is a good choice for a field containing the type of credit card used in a transaction.Check boxes
Use check boxes when the user can choose multiple items in a field. A check box is also a good format for turning a choice on or off or for confirmation (like a check box next to Yes). Remember that the text next to the check box or radio button is the content of a field, not the X or bullet that appears. In other words, you can't count, add, or otherwise manipulate the checks or radio buttons themselves. They're only a format to help the user navigate the field options you've set. If you change a check box field back to a standard field, you'll only see the selected values for the record, not the whole group of choices (Figure 3.37).Figure 3.37. On this layout, the Contact section has five possible entries via a check box set. When you change it back to a standard format (Edit Box), only the entries that had checks next to them still appear.
[View full size image]
