Carriage return in memo fields and queries

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Steve Leferve
    #1

    Carriage return in memo fields and queries

    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


    Tags: None
    • Tom van Stiphout
      #2
      Re: Carriage return in memo fields and queries

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

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

      [color=blue]
      >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
      >[/color]

        Comment

        • Steve Leferve
          #3
          Re: Carriage return in memo fields and queries


          "Tom van Stiphout" <tom7744@no.spa m.cox.net> wrote in message
          news:1e2h7091h1 bctq8i2vk3m1bui ogi33uhfb@4ax.c om...[color=blue]
          > On Sat, 10 Apr 2004 15:49:53 -0400, "Steve Leferve"
          > <lefevre.10@osu .edu> wrote:
          >
          > Experiment with CR LF pairs. That may work better.
          > -Tom.
          >[/color]
          Thanks, Tom. How do I do that?

          Steve


            Comment

            • Tom van Stiphout
              #4
              Re: Carriage return in memo fields and queries

              On Sat, 10 Apr 2004 20:52:55 -0400, "Steve Leferve"
              <lefevre.10@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.


              [color=blue]
              >
              >"Tom van Stiphout" <tom7744@no.spa m.cox.net> wrote in message
              >news:1e2h7091h 1bctq8i2vk3m1bu iogi33uhfb@4ax. com...[color=green]
              >> On Sat, 10 Apr 2004 15:49:53 -0400, "Steve Leferve"
              >> <lefevre.10@osu .edu> wrote:
              >>
              >> Experiment with CR LF pairs. That may work better.
              >> -Tom.
              >>[/color]
              >Thanks, Tom. How do I do that?
              >
              >Steve
              >[/color]

                Comment

                Previous template Next
                Working...