Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office InfoPath
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
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 (formula: An XPath expression made up of values, fields or groups, functions, and operators. Formulas can be used to calculate mathematical values, display dates and times, and reference fields.).

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 Button image, 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.
advertisement