How to return Carriage Returns

Hi,
A field in my query returns the address formatted with carriage returns
(using CHAR(13)) like so:
Address = Name + CHAR(13)
+ Address1 + CHAR(13)
+ Address2 + CHAR(13)
+ City + SPACE(1) + State + SPACE(1) + PostCode
This field is placed in a table.
In the report, it appears that these carriage returns are ignored. Is this
the case?
How can I get this to work? Can I not do it in the query?
thanks
MattTurns out caching was the issue.
thanks
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:e8TrirQpEHA.2068@.TK2MSFTNGP09.phx.gbl...
> Hi,
> A field in my query returns the address formatted with carriage returns
> (using CHAR(13)) like so:
> Address = Name + CHAR(13)
> + Address1 + CHAR(13)
> + Address2 + CHAR(13)
> + City + SPACE(1) + State + SPACE(1) + PostCode
> This field is placed in a table.
> In the report, it appears that these carriage returns are ignored. Is
this
> the case?
> How can I get this to work? Can I not do it in the query?
> thanks
> Matt
>