Insert a default value in a field

Microsoft Office Access 2003

Show All Show All

Insert a default value in a field

  1. Open a datasheet, or open a form in Form view.
  2. Click in the field in which you want to insert the default value.
  3. Press CTRL+ALT+SPACEBAR.

Note  To see the default value in a Microsoft Access database, open the table in table Design view and look at the DefaultValue property. To see the default value in a Microsoft Access project, display the Column Properties view in a database diagram and look at the Default Value column property.