insert LINEFEED in MEMO

[RLyra]

Hi from Brazil.

I want to insert a text into a memo field, with a query, but in a new line. How can I do it ???


Lyra

 

[PaulBricker]

In a query vbCrLf doesn't work. You have to use the Chr() function. So your string would look like this.

strVal = Chr(10) & "Your string here"

Then you would need to use the SelStart to insert it at the end of the existing memo field.

Paul

 

[RLyra]

It is not working.

First I put some text, after I have a second query where I wrote "trim([estrutura]) & Chr(10)" on this field (estrutura). After that, I add some text again.

After all that, it is not working. At the end, I get text plus a sign, plus more text. The sign is that box they use when they have a strange caracter.

Any ideia ??

 

[mikevh]

Try "Chr(13) & Chr(10)" instead of just "Chr(10)".
Chr(13) is a carriage return, Chr(10) is newline.

 

[RLyra]

Still not working. Still have a "box" on the place of line feed!!!

The query is this:

UPDATE [Temp 03] INNER JOIN (Texto INNER JOIN Norma ON Texto.CodProdasen = Norma.codProdasen) ON [Temp 03].valor = Texto.TipReg SET Norma.Estrutura = [estrutura] & Chr(13) & Chr(10);

And after this:

UPDATE (Texto INNER JOIN Norma ON Texto.CodProdasen = Norma.codProdasen) INNER JOIN [Temp 03] ON Texto.TipReg = [Temp 03].valor SET Norma.Estrutura = Trim([estrutura]) & " " & Trim([texto]);

I am cheking it at a form.

Something very strabge is happening here ...
I tryed to copy the text, from the form to this webform, with Ctrl-C and Ctrl-p. When I do it, the linefeed works. If I copy back, from webform to access form, it is Ok. But I cannot do it with more than 25000 records.

What hell is that ????

 

[pelegs]

Could be you need to reverse the order to

Chr(10) & Chr(13)

? Sounds like they are both getting in there, but Access is not so forgiving about which comes first, and I haven't a clue which is it supposed to be, so it is worth a try. Alternately, try this function in place of the Chr functions:

Public Function strGetCrLF() as String
strGetCrLF = vbCrLf
End Function

Peleg
PelegNOSPAM@PStrauss.net

 

[mikevh]

I don't know why copying from form to here and then back
would fix the problem, but I think you have embedded
linefeeds in your memo field that need to be changed to
CR + LF. You might take a look at thread705-431420,
where someone else was having a similar problem. It
contains a function from the Microsoft Knowledge Base you
can use to convert the LF's in your memo field to CRLF.
I tried this myself and it worked fine.