Restrict Table Field to Specific Text Values

[RHONDAK72]

I use Access 2010. Is there a way to restrict a table's field to specific field values. Let's say I have a table called "Fruits" with the field "Type". I want the user to only be able to specify one of these values for the "Type" field:

apple
banana
grapes
kiwi
pear

Is there a way to restrict it so that the user cannot specify anything else except for the one of the 5 values above within the actual table?

Thanks!

 

[Joe4]

There sure is!

Open the table in Design View, and select that Field.
In the Field Properties, go to the Lookup tab.
Enter the following properties:
- Display Control: Combo Box
- Row Source Type: Value List
- Row Source: apple;banana;grapes;kiwi;pear
- Limit To List: Yes
- Allow Value List Edits: No

 

[RHONDAK72]

Thanks so much Joe4!