You use the Page and the Pages properties to display or print page numbers in forms or reports. The + operator supports null propagation the & operator does not. Null propagation means that if any component of an expression is null, the entire expression is also null. Uses the + operator and null propagation to display the values of the City and PostalCode controls if the value in the Region field or control is null otherwise, it displays the values of the City, Region, and PostalCode fields or controls, separated by spaces. Uses the IIf function to display the values of the City and PostalCode controls if the value in the Region control is null otherwise, it displays the values of the City, Region, and PostalCode controls, separated by spaces. 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.
0 kommentar(er)
