Vertical Concatenation

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

Was wondering if there is a way to vertically concatenate
date in field on a form as opposed to the horizontal
default. I.E. If in a text box I write
=[First_Name] & " " & [Last_Name]
I will get "Joe Smith".
Is there a way for my output to look like:
"Joe
Smith"

Thanks
 
Rich said:
Was wondering if there is a way to vertically concatenate
date in field on a form as opposed to the horizontal
default. I.E. If in a text box I write
=[First_Name] & " " & [Last_Name]
I will get "Joe Smith".
Is there a way for my output to look like:
"Joe
Smith"
Click to expand...


The new line sequence in Access is CR, NL so you would write
that expression this way:

=[First_Name] & Chr(13) & Chr(10) & [Last_Name]
 
Back
Top