By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,474 Members | 3,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,474 IT Pros & Developers. It's quick & easy.

Carriage return in memo fields and queries

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a

"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
Nov 12 '05 #3

P: n/a
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


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.