use a carriage return in a query?

[merlin777]

I want to put 2 pieces of information in one text box on different lines e.g. the name of a plant and underneath it the latin name.

I know how to concatenate them - [ProductName] & " " & [LatinName] - in the Field cell but how can I replace that space with a carriage return character (13)?

 

[merlin777]

I want to put 2 pieces of information in one text box on different lines e.g. the name of a plant and underneath it the latin name.

I know how to concatenate them - [ProductName] & " " & [LatinName] - in the Field cell but how can I replace that space with a carriage return character (13)?

I tried:
[ProductName] & Chr(13) & Chr(10) & [LatinName]

but I just got the first string and one line. The second string may have been there but hidden because I couldn't see the second line.

 

[merlin777]

Aha! I was being thick!

Of course I couldn't see it - it was an unformattable query result!

I put the query into a report and adjusted the size of the box and all came good.