Show All

Insert a formula

Formulas are stored in fields and are displayed in the controls that are bound to those fields. When designing a form, you can create formulas in text boxes, rich text boxes, date pickers, and expression boxes.

Note  You should use an expression box only if you do not want to use the result of the formula in another formula or save it as part of a form, because expression boxes only display data and do not store it.

1. In design mode, double-click the control where you want to create the formula.
2. On the Data tab in the Control Properties dialog box, click Insert Formula .

   Note  To create the formula by using the field's properties, right-click the field in the Data Source task pane, and then click Properties.

3. In the Insert Formula dialog box, do one or more of the following:
   • To insert a field or group in the formula, click Insert Field or Group, and then click the field or group in the Select a Field or Group dialog box.
   • To insert a function in the formula, click Insert Function, and then select the function in the Insert Function dialog box. If the function requires an argument, double-click the function in the Formula box, and then click a field or group.
   • To insert a value or mathematical operator in the formula, type the value or symbol for the mathematical operation in the Formula box. The symbols appear in the following table (note that you should include spaces around the division symbol).

     Operation	Symbol
     Add	+
     Subtract	-
     Multiply	*
     Divide	/

Tip

Note  The information in this topic may not apply if you are working with a form designed using Microsoft Office InfoPath 2003 without the service pack installed. Learn more