chr(13) carriage return???

[KIMBOZZZ]

i have a field... well actually a concatenation of trimed fields....but i need to insert a carriage return between some of them... i thought CHR(13) was the kiddie to use ...but all it does is put a square symbol in the sstring . how do i get a carriage return inserted?

thanks in advance.... kimbo

 

[Newman]

I've seen «vbCrLf» somewhere.
Maybe that is what you're looking for.

 

[KIMBOZZZ]

thanks for that... so far i've got ....
=Trim([Home Address]) & IIf(Len(Trim([Home Address])) Is Null,"",Chr(13)) & Trim([Address]) & IIf(Len(Trim([Address])) Is Null,"",Chr(13)) & Trim([City]) & IIf(Len(Trim([City])) Is Null,"",Chr(13)) & Trim([State]) & IIf(Len(Trim([State])) Is Null,"",Chr(13)) & Trim([Zip/Postal Code]) & IIf(Len(Trim([Country])) Is Null,"",Chr(13)) & Trim([Zip/Postal Code]) & [Country]

if i substitute vbcrlf
for chr(13) the vbcrlf is imediatly encapsulated [vbcrlf] and when the report runs i'm asked for the field vbcrlf

it's probably just me and my lack of code knowledge but surely this should be easy!!!!!?

 

[Rich]

& Chr(13) & Chr(10)