Add formatting rules for Microsoft InfoPath 2010

Use the Add Rule button

Out-of-the-box formatting rules can be added by using the Add Rule command.

1. Click a control.

2. On the Home tab, in the Rules group, click Add Rule.

1. Click the type of condition that the rule needs to meet in order to apply, such as Is Blank if you want the rule to apply if the value of the field is blank.

2. Click the type of formatting to apply, such as shading the background color of the cell or modifying the font to indicate a warning.

When finished, the Rules task pane appears and you can make any necessary changes to the rule.

Use the Rules task pane

Complete the following steps to add a formatting rule from the Rules task pane:

1. Create a formatting rule

   1. Click a control.

   2. If the Rules task pane is not visible, then, on the Home tab, in the Rules group, click Manage Rules.

   3. Click New.

      

   4. Click Formatting.

   5. Enter a name for the rule in the Details for text box.

2. Specify the conditions.

   1. In the condition section, click None.

      

   2. If the condition for your rule is based on a field, complete the following:

      1. In the first box, click a field or select Select a field or group.

      2. In the second box, click an operator such as is equal to.

      3. In the third box, enter a value.

         Note:  It is also possible to base a rule on an expression or a set of signable data. For more information about these advanced scenarios, see the corresponding section under Advanced condition scenarios.

   3. Click And to add another condition, and then repeat step 2 or click OK.

      Note:  After adding a second condition, the And button is replaced with a box. Leave and selected if both the first and each subsequent condition needs to be true for the conditional formatting to be applied. Otherwise, if only one of the conditions should be true for the conditional formatting to be applied, click or.

3. Specify the formatting.

   1. Make the desired selections from the Formatting section. From this section you can indicate that text in the control is bold or underlined, change the color of the text or background color of the control, or turn on or off the control.

Data entry patterns

Formatting rules can be based on the text pattern that a user enters into a text field. For example, if you want to collect a United States ZIP code, then you want to make sure that only five numbers, no less, no more, and no alphabetical characters are entered. Likewise, if you want a user to enter an email address , then you can match the input to a pattern that includes text, an “@” symbol, a domain, and a domain suffix such as “.com”.

To do this, from the Operator text box, select Matches Pattern when building the condition, and then select the Select a pattern option. The Data Entry Pattern dialog appears, from which you can select from several pre-defined, standard patterns. If one of these patterns does not meet your needs, then you can indicate a custom pattern. Custom patterns can require the use of special characters, which can be easily inserted by selecting them from the Insert special character box.

Advanced condition scenarios

The following are advanced scenarios that you can use when setting the condition of a data formatting rule.

• Base a rule on an expression

An expression is a set of values, fields or groups, functions, and operators. You can use an expression to set the value of a field in such scenarios as automatically including today’s date on a form, or adding the cost of items entered into an expense report to get the total.

1. In the first box, click an expression.

2. In the second box, enter the expression.

• Base a rule on a set of signable data

If a form requires a digital signature and it has not been signed, you might want to disable the submit button. Or, for example, you can set the background color of the Signature field be a red until a the form is signed. This condition is only supported in InfoPath Filler forms.

1. In the first box, click Select set of signable data.

2. In the Select Set of Signable Data dialog box, select the set of signable data, and then click OK.

3. In the second box, click a condition, and then, in the third box, select any necessary criteria.

• Base a rule on a user’s role

While it is possible to create a form with different views, and display the appropriate view to a user, based on their role, it is also possible to have one view for all users, and hide or display individual controls in the view to a user based on their role. You can also use this to automatically fill in a user’s manager, department, or other information, based on their role. User roles are only supported in InfoPath Filler forms.

1. In the first box, click User’s current role.

2. In the second box, click the operator, such as is equal to.

3. In the third box, click the role or Manage roles to manage user roles.

Top of Page