How Do You Automatically Add Predefined Values To A Microsoft Access Table Field?
Providing a choice of predefined values for a field is useful when values rarely change. For example, in a Salutations column, you might enter predefined values of Mr., Mrs., Ms., Dr., etc. When entering data, the user is presented with a list of choices, and just needs to click the one to be used. You can create a field with predefined values either in Design view or Datasheet view. These instructions apply to Microsoft Access 97. Open your table in Design view. Create a new row in the location where you want your field to occur. If you want to put the field at the end of the rows, click in the first empty row. Name your new field. Click in the Data Type column. A small arrow appears at the right corner. Click in the right corner to obtain a menu of choices. Click in Lookup Wizard. The Lookup Wizard appears. Click the option that indicates you want to type in the values. Click Next. Follow the directions that the wizard provides. Click Finish. Save your table. When you look at your ta
