Show All

Combine text values

1. Open the form, report, or data access page in Design view.
2. Do one of the following:

   Click the Text Box tool in the toolbox.

   On a data access page, you can use a bound span control instead of a text box.

3. Click the section where you want to place the control.
4. Select the control, and then click Properties on the toolbar.
5. In the ControlSource property box, type an expression that concatenates the values from the appropriate fields.

   Tip

   In a form or report in a Microsoft Access database (.mdb), you can also click the Build button to use the Expression Builder to create the expression.

   Example that generates a complete mailing address

   For example, to return an address like

   507 20th Ave. E., Seattle WA 98122

   type this expression:

   =[Address]&", "&[City]&" "&[Region]&" "&[PostalCode]

Note  The Employee Sales by Country and Customer Labels reports in the Northwind sample database have examples of combining text values. To view one of these reports, open the Northwind database in the Samples subfolder of the Office folder, and then open the desired report in Design view.