Carriage Return or New Line in a Concatenated Note

[PRIreland]

How can I encode a carriage return in a concatenated field?

I've got some text that looks like this (say this is from a field called [Q_TEXT]:

THE PART IS QUOTED AT $3.25
MARKUP 1.25

When I run a query, the text will print just like this and that is what I want. It also comes out in a data extract to a text file just like this, that too is what I want.

Now, I need to refine this text to add QUOTE NOTES: in front. So, in the query, I created a column in design view something like

NewText:"QUOTE NOTES:"+XXX+[Q_TEXT].

I've tried to put all kinds of things where the xxx is and can't seem to convince access to put a carriage return (start a new line in other words) between QUOTE NOTES: and Q_TEXT.

I want the final note to looke like:
QUOTE NOTES:
THE PART IS QUOTED AT $3.25
MARKUP 1.25

The formatting is important because this text is exported and then used in another application.

Thank you

Patrick Ireland

 

[Remou]

Try (Chr(13)+Chr(10)).

 

[Golom]

Try

NewText:"QUOTE NOTES:" & Chr(13) & Chr(10) & [Q_TEXT]

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[PRIreland]

Worked great, I like simple fixes like this.

I can't tell you how much time I spent researching this. You'd think somewhere there would have been an answer to this question in Access' help area.

Oh well. At least there is one on Tek-Tips now.

Thank You

Patrick