About defining default values

About defining default values

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.

You can set the DefaultValue property for a field in table Design view or for a control in form Design view. In data access page Design view, use the Value property. 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 (as long as you create the controls after setting the property in table Design view). 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.

Return to Define a default value that is automatically entered in a field or control