Create a value list field in Design view

1. Open the table in Design view.
   
   
2. To insert the field within the table, click in the row below where you want to add the field, and then click Insert Rows on the toolbar.

   To add the field to the end of the table, click in the first blank row.

3. In the Field Name column, type the name for the field, following Microsoft Access object-naming rules.
   
   
4. In the Data Type column, click the arrow and select Lookup Wizard.
   
   
5. In the first Lookup Wizard dialog box, click the option that indicates you will type in the values that you want.
   
   
6. Click Next and follow the directions in the remaining Lookup Wizard dialog boxes.

Note   When you use the Lookup Wizard to create a fixed value list, Microsoft Access sets certain field properties based on the choices you made in the wizard. Once you've created the field, if you add it to a form, Microsoft Access copies its definition into the form. The combo box or list box is created automatically for the form. However, if you change the definition of the value list field in the table after adding it to a form, those changes will not be reflected in that form. To correct this, delete the field from the form and then add it again. For information on the properties that the Lookup Wizard sets, click .