vbNewLine - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

vbNewLine

Willem Els

50 days ago

Can someone help whille I still have some hair left.
Today at the most important time my most simple memo Did not wat to display the data correct.
It copies all the data in one long string
I have never had an issue doing this basic programing. Any Ideas?

I have 10 fields that needs to be copied into the memo field but copies it as a string do not go to the next line.
Here are the different versions I tried.

MemoFld = "Field1: " & Field1 & vbCrLf & _
          "Field2: " & Field2 & vbCrLf & _
          "Field3: " & Field3

MemoFld = "Field1: " & Field1 & Chr(10)& Chr(13) _
          "Field2: " & Field2 & Chr(10)& Chr(13)& _
          "Field3: " & Field3

MemoFld = "Field1: " & Field1 & vbNewline & _
          "Field2: " & Field2 & vbNewline & _
          "Field3: " & Field3

Wrong Answer
MemoFld = "Field1: " & Field1 & "Field2: " & Field2 & Field3: " & Field3

Required Answer

Field1: Job 1
Field2: Coffee
Field2: Black with no Sugar

	Kevin Robertson @Reply 50 days ago
Is the field Rich Text? If so, you will need to use `<.br.>` tags. `MemoFld = "Field1: " & Field1 & "<.br.>" & _ "Field2: " & Field2 & "<.br.>" & _ "Field3: " & Field3` I added periods otherwise the site will add actual line breaks.

	Willem Els OP @Reply 50 days ago
Hi Kevin, yes Rich text, long text. Tired your solution, still the same

	Willem Els OP @Reply 50 days ago
Thanks Kevin, You are a hero. the < br > did the trick

	Richard Rost @Reply 50 days ago
Yep - Kevin hit the nail on the head. Rich text = HTML tags. Kinda. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View