Carriage return symbol / character?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I want to have a function return text and some carriage returns, what's
the way I can insert a carriage return? Word uses ^p, Filemaker has a button
to push which puts the character there, and other programs I've seen use /n
or /r.

I tried doing a search on the discussion list and checking the online help,
but didn't see this anywhere.

Thanks for the help!
 
If I want to have a function return text and some carriage returns, what's
the way I can insert a carriage return? Word uses ^p, Filemaker has a button
to push which puts the character there, and other programs I've seen use /n
or /r.

I tried doing a search on the discussion list and checking the online help,
but didn't see this anywhere.

Thanks for the help!
Click to expand...

In Access?
= "This is line 1." & chr(13) & chr(10) & "This is line 2."

In VBA?
Use as above
or
= "This is line 1." & vbNewLine & "This is line 2."
or
= "This is line 1." & vbCrLf & "This is line 2."
 
Back
Top