Exporting memo fields more than 255 characters from a query

[CaperTS]

Hi all. I'm new here, please be kind.

I have a database with long memo fields, more than 255 characters in many cases, that I have to export in a very specific format so that the information can be imported into another program. These fields are questions, answers, and explanations, which is why some of these memo fields are so long.

The problem I am having is that I need each field entirely on one line before breaking to the next line (see below). Instead, some of these fields are returning on 2 or 3 lines rather than one.

This is the format which I am trying to export to (numbers are just placeholders for line returns):

1) Question
2)
3) Answer A
4) Answer B
5) Answer C
6) Answer D
7)
8)
9) Explanation
10)
11)
12) Question
13)
14) Answer A
15) Answer B
... and so on, and so forth...

The query code I am using is

Question: Chr(13) & Chr(10) & [QUESTIONS.QUESTIONBODY] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [QUESTIONS.ANSWER_A] & Chr(13) & Chr(10) & [QUESTIONS.ANSWER_B] & Chr(13) & Chr(10) & [QUESTIONS.ANSWER_C] & Chr(13) & Chr(10) & [QUESTIONS.ANSWER_D] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [QUESTIONS.EXPLANATION] & Chr(13) & Chr(10) & Chr(13) & Chr(10)

I have 90% of the query (though it may not be the prettiest way to write it), I just need to figure out how to get these fields on a single line. Any tips or suggestions?

[June7]

What do you mean by 'on 2 or 3 lines' - are you viewing the exported file, is it a text file, is the line simply wrapping?