How to Concatenate Fields in a Label MS Access

‍

‍

Here’ s how to do it:

‍

1. Navigate to the form or report where you want to add the concatenated label. Switch to 'Design View' by right-clicking the form.
2. Under the 'Data' tab, go to the 'Control Source' and click the ellipsis icon.
3. In the 'Control Source' property, enter an expression to concatenate the fields.
4. Save your form by clicking the save icon.