About defining a default value that is automatically entered in a field or control (MDB)
Note The information in this topic applies only to a Microsoft Access database (.mdb).
You can use the DefaultValue property to specify a value that will be automatically entered when you add a new record. For example, if most of your suppliers are in New York, you could set the City field of the Suppliers table to have a default value of "New York." You can accept the default value or type a new value over it.
In most cases, you'll want to add the default value to the field in table Design view, since that default value will be applied to controls based on that field. If the control is unbound, however, or if it's based on data from a linked (external) table, you'll need to set the default value for the control in the form or data access page.