Euro symbol and ascii code for new line

[#1]

Hi all,

I have two values that I want to show on separate lines. One of the values should be formatted as money, with the euro symbol. I use chr(13) to separate the two lines. But, this does not work. When I switch to a $ symbol, or something else, it works fine. Please see attachment for an example. It is the same if I use QV 8.5 and 9.

Any ideas, or tips on work-arounds?

[#2 · Accepted solution]

Use chr(10):

=sum(Sales) & chr(10) & money(sum(Cost), '$' )

[#3]

You have to use & chr(13) & chr(10) for new line.

Regards.

[#4]

Thanks to both of you! I had the feeling this was an easy one. It seems to work with only chr(10) as well as the combination chr(13) & chr(10).

[#5]

only chr(10) might not work in AJAX client -- use the combination chr(13) & chr(10) instead