Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Euro symbol and ascii code for new line

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?

1 Solution

Accepted Solutions
Not applicable
Author

Use chr(10):

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

View solution in original post

4 Replies
Not applicable
Author

Use chr(10):

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

Not applicable
Author

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

Regards.

Not applicable
Author

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).

Not applicable
Author

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