Carriage return in memo fields and queries

[Steve Leferve]

I'm making a report that uses a query as its source. The query references a
memo field that typically has carriage returns in it. When I go to run the
report, it seems to have truncated the fields at the carriage return.

Are there any particular problems using such fields coming through a query
in a report? The query really seemed to hack it up.

Steve Lefevre

[Tom van Stiphout]

On Sat, 10 Apr 2004 15:49:53 -0400, "Steve Leferve"
<le********@osu.edu> wrote:

Experiment with CR LF pairs. That may work better.
-Tom.

I'm making a report that uses a query as its source. The query references a
memo field that typically has carriage returns in it. When I go to run the
report, it seems to have truncated the fields at the carriage return.

Are there any particular problems using such fields coming through a query
in a report? The query really seemed to hack it up.

Steve Lefevre

[Steve Leferve]

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:1e********************************@4ax.com...

On Sat, 10 Apr 2004 15:49:53 -0400, "Steve Leferve"
<le********@osu.edu> wrote:

Experiment with CR LF pairs. That may work better.
-Tom.

Thanks, Tom. How do I do that?

Steve

[Tom van Stiphout]

On Sat, 10 Apr 2004 20:52:55 -0400, "Steve Leferve"
<le********@osu.edu> wrote:

Well, CR=Chr$(13), and LF=Chr$(10).
Perhaps you could write some code that replaces single CR characters
by a CRLF pair.

-Tom.

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:1e********************************@4ax.com.. .

On Sat, 10 Apr 2004 15:49:53 -0400, "Steve Leferve"
<le********@osu.edu> wrote:

Experiment with CR LF pairs. That may work better.
-Tom.

Thanks, Tom. How do I do that?

Steve