How to Concatenate Fields in a Label MS Access

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to combine multiple fields into a single label in MS Access.

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.

📌 Why this matters

Concatenating fields in an MS Access label allows database users to display combined data — such as full names or addresses — in a single, readable label on forms and reports without duplicating or restructuring underlying table data. This technique uses Access's built-in Control Source expression builder, making it accessible to users without advanced programming skills. Mastering field concatenation in MS Access improves data presentation, reduces manual formatting effort, and helps teams build cleaner, more professional database interfaces. It is a foundational skill for anyone building or managing Access forms and reports.

Your product deserves an interactive demo

Start free

How to Integrate a Microsoft Excel Database with Excel

How to Integrate Google Calendar with an MS Access Database

How to Integrate Google Sheets with an MS Access Database