Represents the value of a text field.
If no formula is associated with this property, the text field is an input field that users use to enter and edit values. If a formula is associated with this property, the text field is an output field that displays a calculated value derived through the formula.
Displaying long-form calculated text through a text field
Text boxes currently do not support displaying text calculated through a formula. You can achieve the same effect using a text field, if you instruct it to display multiple lines and you set its label to an empty text string.
Associate a formula with this property to determine the text displayed to your user using values entered in your app and logic that derives from these values. Use & to join various text strings together for use in the body. Use the NEWLINE function to produce line breaks, enabling the text to consist of multiple paragraphs.
Consider this formula:
The formula above causes the text field to display this text if the value of the Temperature field is greater than 85:
The temperature is untolerable!
It's time to get an air conditioner!
If the value of the Temperature field is less than or equal to 85, this text is displayed:
The temperature is quite pleasant!
For more examples on how formulas can be used to calculate what text to display, refer to the Body property of email report buttons.
Referencing text field values from formulas
When referencing a text field value from a formula, there is no need to write .Value,Value after the field name if a text string is sought. These formulas are equivalent:
Above, & is looking to join two text
strings together. As TextField1 can return a text string through its
Value property, .Value,Value is implied.
Returns a text string consisting of the value of TextField1 joined together with "test".