301,263 views
32 votes
32 votes
from design view, modify the gender field to use a lookup list with male and female in a single column. limit the field to values in the list only.

User Robert Groves
by
2.4k points

2 Answers

9 votes
9 votes

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:

  1. Open the design view of the form or table.
  2. Locate the gender field and right-click on it to open the field properties.
  3. In the Lookup tab, select 'Row Source Type' as 'Value List'.
  4. In the 'Row Source' field, enter 'Male;Female' (without quotes), separating the values with a semicolon.
  5. 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.

User Leonid Pyrlia
by
2.8k points
18 votes
18 votes

I just wanted to put i don't know lol

User Seth Feldkamp
by
2.6k points