<div>
Create a query and add below formula in new field. It will give you result as you required<br />
<br />
Color: [Field1] &amp;&nbsp;&quot; ,&quot; &amp;&nbsp;[Field2] &amp;&nbsp;&quot; ,&quot; &amp;&nbsp;[Field3]
</div>


Create a query and add below formula in new field. It will give you result as you required

Color: [Field1] & " ," & [Field2] & " ," & [Field3]

<div>
<div class="content wysiwyg-content">
I have a form with 5 fields. &nbsp;One or all 5 may have text data in them. &nbsp;Then on the form I also have a field that I want to combined the data from the 5 (or less) field into separate with a comma and a space.<br />
<br />
So if for example field 1 has &quot;Green&quot;, field 2 has &quot;Orange&quot;, and field 3 has &quot;Purple&quot;, then the combined field would read... &nbsp;&quot;Green, Orange, Purple&quot;<br />
<br />
How can I do this so that the combined field is updated after each of the other fields are updated?
</div>
</div>


I have a form with 5 fields.  One or all 5 may have text data in them.  Then on the form I also have a field that I want to combined the data from the 5 (or less) field into separate with a comma and a space.

So if for example field 1 has "Green", field 2 has "Orange", and field 3 has "Purple", then the combined field would read...  "Green, Orange, Purple"

How can I do this so that the combined field is updated after each of the other fields are updated?

How combine 5 test fields together separate with a comma and space

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.