How to Set a Default Value in Access

You can enter a default value to specify a value that is automatically entered in a field when a new record is created. For example, if most of your clients are from Texas, you could set the default value for the State field to “TX.” When a user adds a record to the table, they can either accept the “TX” default value for the State field or enter their own value.

1. In Design View, click the field you want to add a default value to.
2. Click the Default Value box.
3. Enter the default value you want to appear in the field for new records.