Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011

    Unanswered: Please just go to the next line!!!

    I am having a major brain freeze on this. I have data in which one of the text fields is "multi-line". It uses Chr(10) as the character to indicate the line break (which Crystal Reports uses just fine).

    In my Access report, however, it is giving me the little question mark symbol. I can find the Chr(10), and I tried replacing the it with (Chr(10) & Chr(13)) which should equate to vbCrLf, but it isn't working.

    This should be simple (and probably is) - I just think I've had too much lately ...

    Please set me in the right direction!!! (I am still trying to phrase my Google search to give me something even remotely related to my problem)

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    ok, I found the answer. Sometimes, it really is as simple as it should be ...

    Apparently I was remembering correctly about replacing Chr(10) with Chr(10) & Chr(13) ... except the order matters, and it should be Chr(13) & Chr(10).


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •