Query to add <br> after everyfull stop

[KenshiroUK]

Is it possible to add a <br> after every full stop within access? I currently had a description field that contains carriage returns. What I wish is add a <br> after every fullstop instead. Can it be done within a query?

Example

I currently had a description field that contains carriage returns.<br> What I wish is add a <br> after every fullstop instead. <br>

 

[CJ_London]

Use the replace function:

replace(myText,"." & vbCr,".<br>")

you may also find you have a combination of carriage return and linefeed - which is vbCrLf