Space(5)

  • Thread starter Thread starter BFB
  • Start date Start date
B

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?
 
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?
Click to expand...

& Chr(13) & Chr(10)

HTH - Peter
 
Back
Top