How to Display All Field Values in a Textbox

Published:

Updated:

Many users prefer to display all field values in a text box. This requirement can be achieved using a combination of the LookupSet function and the Join function. Follow the steps below to show all field values in the text box:

Begin by selecting the desired text box where you intend to showcase all field values. Right-click on it and select Expression.
Embed the following expression into the text box to showcase all the values with comma-separated:
```
=Join(LookupSet(1, 1, Fields!Name.Value, "DataSet1"), ", ")
```

Be sure to substitute Fields!Name.Value with the relevant field name from your dataset and "DataSet1" with your dataset’s identifier.

Preview the report to see the comma-separated values displayed within the text box.

The above-designed report can be downloaded here.

Was this article useful?

Dislike

Comments (0)

How to Display All Field Values in a Textbox

Access denied