Search results

  1. B

    Check whether first line of a memo field is empty

    I wrote the subject before realizing that any line break in the text would cause the same issue. So, indeed I want to remove all line breaks from the text. Thanks again.
  2. B

    Check whether first line of a memo field is empty

    Thanks for this quick response! Google is still my friend though. I found Chr(13) + Chr(10) in a string represent a line break, so I have solved my issue with below code: Private Sub ReplaceLineBreaks() Dim strMemo As String strMemo = Me.Commentaire strMemo =...
  3. B

    Check whether first line of a memo field is empty

    Hi, Our quotation tool, which is built in access 2003, has a memo field, which is extracted in a .txt file, to be uploaded by another system. When the user starts the memo field with a blank line, by hitting the enter key, the upload file writes the memo field as a new line, separating it...
  4. B

    Ben De Vriendt - new member

    Hello all, I'm exited joining a forum dedicated to MS Access. 2 years ago I have taken on the responsibilities to keep poorly designed access tools running. This while I never touched VBA before and was only accustomed to working with macro's. As some of these tools had quite some VBA...
Back
Top Bottom