Chr(10) & Chr(13) Don't Work In Expression Builder 1

[Ramjet]

Hello All,

I have a very simple expression that I am building
and want to implement a carriage return but I am at a
loss for how to do it. vbcrlf doesn't work, chr(10) & chr(13) don't work so how does one concatenate a carriage return to the end of a text string?

In case your wondering the expression is below:

=[A_ADDR1] & IIf(IsNull([A_ADDR2]),"",[A_ADDR2]) & [A_CITY] & ", " & [A_STATE] & " " & [A_ZIP]


TIA

Ramjet

 

[gwinn7]

Have you tried to switch the order of the Chr()s? Like:

"Chr(13) & Chr(10)"

Gary
gwinn7