Create a value list field in Datasheet view

1. Open the table in Datasheet view.
   
   
2. To insert a value list field within the table, click in the column to the right of where you want to insert the field, and then on the Insert menu, click Lookup Column.
   
   
3. In the first dialog box of the Lookup Wizard, select the option that indicates you will type in the values that you want.
   
   
4. Click Next and follow the directions in the remaining Lookup Wizard dialog boxes.

   When the Lookup Wizard is finished, the value list field is added to your datasheet. By default, the new value list field will be given a name in the form, "Field#," where # is some number. You can change this name if you want. To find out how to change a field name in Datasheet view, click .

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 .