![expressions store expressions store](https://121clicks.com/wp-content/uploads/2018/03/dogs_catching_treats_in_mid_air_christian_vieler_08.jpg)
Uses the Trim function to display the value of the Address control, removing any leading or trailing spaces. Uses the Right function to display the last 2 characters of the value in a field or control called AssetCode. Uses the Left function to display the first character of the value of a field or control called ProductName. In this example, the & operator is used to combine the FirstName field, a space character (enclosed in quotation marks), and the LastName field. The expressions in the following table use the & (ampersand) and the + (plus) operators to combine text strings, built-in functions to manipulate a text string, or otherwise operate on text to create a calculated control.ĭisplays the values that reside in table fields called FirstName and LastName. Note You can also use expressions in a form or report when you Highlight data with conditional formatting. To create a calculated control, you enter an expression in the ControlSource property of the control, instead of in a table field or query. The tables in this section provide examples of expressions that calculate a value in a control located on a form or report.