In an earlier thread I got some good advise on concatenating text
strings and line break characters: Chr(13) & Chr(10)
However, I cannot make this work if I have a text string in a database
field like for instance: "This is line 1 <br>This is line 2<br>This is
line 3"
I assume it would somehow be possible to make a Replace function and get
the above to output in the report like this:
This is line 1
This is line 2
This is line 3
But exactly how should this be done?
Brendan Reynolds - 31 Oct 2005 14:36 GMT
=Replace([YourFieldName], "<br>", Chr$(13) & Chr$(10))

Signature
Brendan Reynolds
> In an earlier thread I got some good advise on concatenating text strings
> and line break characters: Chr(13) & Chr(10)
[quoted text clipped - 11 lines]
>
> But exactly how should this be done?