Space(5)

[BFB]

In trying to combine two fields I know that Left
([Field1], 10) & Space(5) & Left([Field2], 10) would put
5 spaces between the two fields. What is the expression
if I want Field2 to be on the next line instead of 5
spaces later?

 

[Peter Doering]

In trying to combine two fields I know that Left
([Field1], 10) & Space(5) & Left([Field2], 10) would put
5 spaces between the two fields. What is the expression
if I want Field2 to be on the next line instead of 5
spaces later?

& Chr(13) & Chr(10)

HTH - Peter