Report - Line Break

[DanKay1]

I am trying to create report that will show one field from the database. That field is a memo field and its very long, I would like to break it to the next line at specific places, but I can't break it at specific places because Access Reports doesnt understand \n.

Here is a sample field from the database:

"Text text \n Text2 text2 \n Text3 text3"

I want it to show up in report as"
Text text
Text2 text2
Text3 text3

Thanks in advance...

 

[RoyVidar]

If you have control enough over the text to be able to insert \n, then try vbCrLf in stead:

[tt]"Text text " & vbCrlf & " Text2 text2 " & vbCrLf & " Text3 text3"[/tt]

Roy-Vidar

 

[PHV]

"Text text \n Text2 text2 \n Text3 text3"
Something like this ?
Replace([database text], "\n", vbCrLf)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244