Value property

TextField.Value — Text

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 temperature is " & IF(Temperature > 85, "untolerable!" & NEWLINE() & NEWLINE() & "It's time to get an air conditioner!", "quite pleasant!")"The temperature is " & IF(Temperature > 85; "untolerable!" & NEWLINE() & NEWLINE() & "It's time to get an air conditioner!"; "quite pleasant!")

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:

"test" & TextField1"test" & TextField1
"test" & TextField1.Value"test" & TextField1,Value

Above, & is looking to join two text strings together. As TextField1 can return a text string through its Value property, .Value,Value is implied.

Examples

TextField1 & "test"TextField1 & "test"

Returns a text string consisting of the value of TextField1 joined together with "test".

TextField1.Value & "test"TextField1,Value & "test"

Returns a text string consisting of the value of TextField1 joined together with "test". Writing out the Value property in formulas (by writing TextField1.ValueTextField1,Value) is rarely necessary.