Address Lines and Carriage Returns

[baloos]

Hi,

I want my query to output an address in one field with carriage returns, where the address lines in the source table are held in individual fields.

So I try...

SELECT [Address1] & Chr$(13) & [Address2] & Chr$(13) & [Address3] etc..

This does not work.

However, if I use a text box on a form, with "New Line in Field" set, and then in code use Sendkeys to post the address and the carriage returns as above, it does work.

Can this be done simply in a query? If so how?

Thanks

--
Richard

 

[RuralGuy]

Try:
SELECT [Address1] & Chr(13) & Chr(10) & [Address2] & Chr(13) & Chr(10) etc...