Report query syntax to create a new line ?

[Jack Spratt]

I am creating a field in a report query where I wish to form the string result to appear as several lines in a report field.

eg.

multiline: ([field1]&Chr(10)&[field2])

I just get a square block character showing in the report field. Is it possible to do this ??

(Reason for the expression is that I am 'closing up' blank addresses/address fields)

thanks

 

[boblarson]

Try changing this:

([field1]&Chr(10)&[field2])

to this:

([field1] & Chr(13) & Chr(10) & [field2])

 

[Jack Spratt]

Many thanks Bob !