Ahh, thank you so much!
> On 15 May 2019, at 22:42, Drew Jensen wrote:
>
> Howdy,
>
> The carriage return is in the string but in the case of the Query designer
> the result grid only displays single line data so it appears it is not
> there.
>
> If the query is used to populate controls on a
Howdy,
The carriage return is in the string but in the case of the Query designer
the result grid only displays single line data so it appears it is not
there.
If the query is used to populate controls on a form (grid or single field)
there is a property for the control 'MultiLine Input' and
The base documentation states that you can get a line break using Char(13) e.g.
SELECT "Firstname"||' '||"Surname"||Char(13)||"Road"||Char(13)||"Town" FROM
"Table"
However, when I run this I just get the concatenated query on one line with no
line breaks.
What am i doing wrong?
Thanks for