How do I add CR/LF in string? (VB)

Topic

New Reply

Hi folks,

How do I add a newline to a string in VB? I tried:

s = “Line 1 ” + Chr(10) + Chr(13) + “Line 2”

But although this works on a c++ stream it does not here…? In ASCII, CR = 0x0D and LF = 0x0A.

Reply | Quote

Replies

You could try
s = “Line 1 ” & vbCrLf & “Line 2”

Reply | Quote

Ohhh I see – I knew it was simple – thanx’

Reply | Quote

Word just uses vbCr (Ascii 13) in a document. If you insert vbCrLf, the line feed (Ascii 10) will be stripped automatically.
If you mean a manual line break, that would be ChrW(11) or vbVerticalTab.

Klaus

Reply | Quote

Thanks for pointing that out. That raises the question: in which case(s) should one use vbCrLf instead of vbCR in Word VBA?

Reply | Quote

If you build strings to insert into a document, you can use either (vbCr makes more sense I think).

But in many other cases, you’d use neither

In Find/Replace, you should use ^p (and definitely not ^13!).

If you insert some text, [Selection].InsertParagraph (or .InsertParagraphBefore, .InsertParagraphAfter) is probably safest.

Klaus

Reply | Quote

As far as I know, you don’t need to use vbCrLf in Word VBA. As the prefix indicates, it’s a general VB constant, available in all dialects of VB/VBA.

(Long live consistency: Word uses vbCr or Chr(11) to start a new paragraph/line, Excel uses vbLf to start a new line within a cell, and Access uses vbCrLf to start a new line within a field value)

Reply | Quote

Yes, there appears to be a consistently individual approach in each case.

Alan

Reply | Quote

Thanks guys.

Reply | Quote