<div>
Use this In an update query:<br />
<br />
UPDATE YourTable<br />
SET YourField = Replace(YourField, &quot;,&quot;, Chr(10) &amp;&nbsp;Chr(13))<br />
<br />
Make a backup before testing any action query.
</div>


Use this In an update query:

UPDATE YourTable
SET YourField = Replace(YourField, ",", Chr(10) & Chr(13))

Make a backup before testing any action query.

<div>
Thanks, worked fine, just needed to amend to &quot;, &quot;&nbsp;i.e. include the space character to be replaced as well.
</div>


Thanks, worked fine, just needed to amend to ", " i.e. include the space character to be replaced as well.

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I am importing a list of addresses into an Access table and a typical address is:<br />
100 High Street, Some Town, Some County, Some Postcode<br />
<br />
I need to use the replace function to get it to look like:<br />
100 High Street<br />
Some Town<br />
Some County<br />
Some Postcode<br />
<br />
Am happy to replace function at query level to &quot;a&quot; with &quot;b&quot;, but not sure how to handle the above regarding Returns and Linefeeds, Thanks
</div>
</div>


Hi all,

I am importing a list of addresses into an Access table and a typical address is:
100 High Street, Some Town, Some County, Some Postcode

I need to use the replace function to get it to look like:
100 High Street
Some Town
Some County
Some Postcode

Am happy to replace function at query level to "a" with "b", but not sure how to handle the above regarding Returns and Linefeeds, Thanks

Replace &quot;, &quot; with Return and Line Feed - Replace Function Microsoft Access

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.

Replace &quot;, &quot; with Return and Line Feed - Replace Function Microsoft Access

Replace ", " with Return and Line Feed - Replace Function Microsoft Access