Final answer:
To modify the gender field in design view to use a lookup list with male and female in a single column and limit the field to values in the list only, follow these steps.
Step-by-step explanation:
To modify the gender field in design view to use a lookup list with male and female in a single column and limit the field to values in the list only, follow these steps:
- Open the design view of the form or table.
- Locate the gender field and right-click on it to open the field properties.
- In the Lookup tab, select 'Row Source Type' as 'Value List'.
- In the 'Row Source' field, enter 'Male;Female' (without quotes), separating the values with a semicolon.
- Check the 'Limit to List' option to restrict the field to values in the list only.
By making these modifications, the gender field will use a lookup list with male and female in a single column, and users will only be able to choose values from the list.