Addind Carraige reuturns to a line in a query

[marrett]

I want to a a carraige return a line on a query.

EX:

address1 & <CR> & Adress2 & <CR> & Address3
I want to do this so that when the report prints out it does not print empty lines.

Please help

thanks Maria

 

[Rich]

Do it on the report =[Address1] & Chr(13) & Chr(10) & [Address2] & Chr(13) & Chr(10) & [Address3]

 

[marrett]

The Char(13) Leaves a Box in the block. Is there any other way to do it? Or a way to get the box to go away?


Thanks,

Maria