Show All

Set the default value for a field in the data source

A default value is the initial value that a field contains. It can be standard text or a formula.

Note  If a field has a picture or file attachment (base64) data type, you cannot set a default value for it. Instead, you can set the default value for a control that is bound to the field.

1. In design mode, if the Data Source task pane is not visible, click Data Source on the View menu.
2. In the Data Source task pane, right-click the field whose default value you want to set, and then click Properties on the shortcut menu.
3. On the Data tab in the Field or Group Properties dialog box, do one of the following:
   • To add a standard default value, type the default value for the field in the Value box.
   • To add a formula that calculates the default value, click Insert Formula , and then, in the Insert Formula dialog box, create the formula. To automatically update the value in the control each time the formula is calculated, select the Update this value when the result of the formula is recalculated check box.