removing multiple enter characters

Results 1 to 2 of 2

Thread: removing multiple enter characters

  1. #1
    Join Date
    Dec 1969

    Default removing multiple enter characters

    I need to remove multiple enter characters before they are saved in the database. They need to be replaced with just one enter character. I've tried the replace function, but it doesn't like vbcrlf vbcrlf. Anyone know how to do this??

  2. #2
    Join Date
    Dec 1969

    Default You *can* use Replace

    Let s be the string you wish to replace all double enters with one enter.<BR><BR>s = Replace(s, vbCrLf & vbCrLf, vbCrLf)<BR><BR>You needed to add the string concatenation character (&) between the two vbCrLfs. hth

Posting Permissions

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