Define a default value in table Design view

1. Open a table in Design view.
   
   
2. In the upper portion of the window, click the field you want to define a default value for.
   
   
3. In the lower portion of the window on the General tab, click the DefaultValue property box, and then type the default value (such as New York) or an expression (such as Date()).

   To view examples of default values, click .

Notes  

• Setting the DefaultValue property for a field has no effect on existing data. However, you can replace a field's current value with the default value by pressing CTRL+ALT+SPACEBAR.
  
  
• If you define a default value for a Yes/No field in a database that will be used internationally, enter an equal sign before the value, and Microsoft Access will display the default value in the local language. For example, enter =Yes to have Microsoft Access display "Ja" in Germany. You must set the DisplayControl property for the field to Text Box or Combo Box to see the value.