Use form variables

A form variable represents a hidden, calculated value that can be used in calculated value controls, formulas, and rules. It can also be bound to a column without being displayed in the form.

Form variables are available on the Named Controls tab in the Formula Builder and they are prefixed with an underscore "_".

To use form variables

1. In the Designer tab of the Forms designer ribbon, click Form Variables.

   The form variables dialog box opens.

2. Add, delete, or edit the form variables that appear on the left hand side.

   

   View options

   • Name: The name of the form variable.
   • Save as data type: The data type to convert to when the form is saved.
   • Connected to: The field to bind the variable to.
   • Recalculate formula on:
     • View mode: Recalculate the value when the form is displayed in view mode at run time.
     • New mode: Recalculate the value when the form is displayed in new mode at run time.
     • Edit mode: Recalculate the value when the form is displayed in edit mode at run time.
   • Formula: The runtime formula to be calculated. Use the Formula Builder to create the formula.