vbcr into textbox - issues

[spinkung]

hi all,

I am trying to append several rows of comments from a table to a single text box. I am trying to put each new row on a new line using 'vbcr' but when i check the text box the rows are not on seperate lines but seperated with black lines as below......

comment1lcomment2lcomment3lcomment4etcl

here's what i'm using....

Do
Me.comments.Value = LTrim(RTrim(rs1("comments").Value)) & vbCr & Me.comments.Value
rs1.MoveNext
Loop Until rs1.EOF

Can anyone help?

Cheers,
Spinkung.

 

[Dennisk]

a carriage return returns the cursor position to the beginning of the current line. try vbCr & vbLf. Its the line feed that actually throws a new line.

 

[RuralGuy]

Or use the combined constant of vbCrLf. BTW, as the originator of the duplicate posts, when *you* edit those posts, delete is one of your options. It will help the moderator.

 

[spinkung]

Excellent, thanks for the reply.

 

[modest]

Or use vbNewLine

 

[The_Doc_Man]

Also, depending on your character set for that box, vbCR and vbLF might echo as funky characters anyway. Remember that Access is NOT a word processor so it doesn't know what a <CR> or <LF> really means.

 

[modest]

Doing a chr(10) & chr(13) is also something you might want to use. It is what is needed in a Report's textbox since vbCR, vbLF, vbCRLF, vbNewline, or any other vb* constant is not recognized.

 

[RuralGuy]

It may not make a difference but the CrLf sequence is Chr(13) & Chr(10).

 

[modest]

It may not make a difference but the CrLf sequence is Chr(13) & Chr(10).

Yes, yes, that is what I meant. Do not use the 10 then 13 as my previous post stated, 13 -> 10 is the correct order and order does matter. Thanks for correcting me Rural.

 

[RuralGuy]

NP Modest.