Access 2002 Programming by Example

Creating a Calculated Control

A bound or unbound control can easily be converted into a calculated control. Simply right-click the control and choose Properties. Click the Build button of the Control Source property to enter the expression builder. Assuming that you have a City, State, and Zip field in the table you are accessing, you can type an expression (or use the builder to help fill in the expression) similar to the following:

[City] & ", " & [State] & " " & [Zip] 

This expression uses the ampersand (&) operator to concatenate (bring together) field values with literal (constant) values. The fact that City, State, and Zip are all enclosed in brackets indicates that they are all field values. The comma and spaces are literal values. Together, ...