Line return in an expression

[Max Moor]

Hi All,
I have a query, actually and SQL statement as an underlying query for
a report. One field is an expression that sticks an address, city, state,
and zip code together.
Is there a control character or something that I can put in the
expression to force a line feed between the address and the city? I tried
shift-return, but when I save the query and reopen it, it's gone.

Thanks, Max

 

[Fredg]

Max,
Try ....

Exp:[Address] & chr(13) & chr(10) & [City] & ", " & [State] & " " & [Zip]

 

[Max Moor]

chr(13) & chr(10)

Thanks Fred. It never crossed my mind to do that. Works like a charm.