Excel I think has built in logic to auto-complete Tables, which I'm not sure exists in Access
However, in Table Design > View > Design View,
setting a Fields, Display Control to List Box, with Row Source "Male";"Female" appears to work.
A combo box could be used if you wanted to allow for other terms.
with regards changing the format of a mail merge document, via google
- In the main Word mail merge document, select the date field.
- Right-click the field and choose Toggle Field Codes from the drop-down menu to display the field code. You can also press Shift + F9 to display the field code.
- If necessary, delete \*MERGEFORMAT from the field code.
- Enter the switch after the field name (such as \@ “MMMM d/yy”). Be sure to type a space after \@.
- Right-click the field and choose Toggle Field Codes from the drop-down menu to hide the field code. You can also press Shift + F9 to hide the field code.
- Right-click in the field and select Update Field from the drop-down menu. You can also press F9 to update the field.
- Run the merge by selecting Edit Individual documents from the Mailings tab in the Ribbon and then click OK in the dialog box. In the merged document, the date should appear in the switch format.
So for example; {MERGEFIELD RegistrationDate \@ “dd-MMm-yyyy”}