Thursday, December 7, 2017

Change how negative numbers are displayed in a text box or expression box

Change how negative numbers are displayed in a text box or expression box

In Microsoft Office InfoPath, you can add data formatting to text box, expression box, and date picker controls on your form template to specify how dates, times, and numbers are displayed when users enter them into forms that are based on your form template.

You can specify how negative numbers are displayed only for text box controls that have a decimal or whole number data type, or for expression box controls that are formatted to display a decimal or whole number.

  1. Double-click the text box control or expression box control whose data you want to format.

  2. In the Control Properties dialog box, do one of the following:

    • If you are working with a text box control, click the Data tab.

    • If you are working with an expression box control, click the General tab.

  3. Do one of the following:

    • For a text box, ensure that the Data type list displays the appropriate data type, and then click Format.

    • For an expression box, ensure that the Format as list displays the appropriate data type, and then click Format.

  4. In the Display negative numbers like this list, under Other options, select the display style that you want.

No comments:

Post a Comment