Quick summary
This tutorial shows how to concatenate fields in a label using MS Access by setting a custom expression in the Control Source property of a form or report. Follow the steps below to merge multiple database fields into one display label without writing complex code.
Steps
- Navigate to the form or report where you want to add the concatenated label, then switch to Design View by right-clicking the form.
- Under the Data tab, go to the Control Source property and click the ellipsis icon to open the expression builder.
- In the Control Source property field, enter an expression to concatenate the fields you want to combine.
- Save your form by clicking the save icon to apply the concatenated label expression.
