Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013
    Posts
    1

    Unanswered: Query to add a <br> after a full stop.

    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>

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    UPDATE mytable SET mycolumn = REPLACE(mycolumn, ".", ".<BR>"

    or if you want the CRF to be used within Access
    UPDATE mytable SET mycolumn = REPLACE(mycolumn, ".", "." & vbcrlf
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •