New Line Character

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

Guest

Hi,

I am appending text that I want to put in a text box but I want each group
of text I receive to be on its own line. What is the new line character in
access?

Thanks
bbdobuddy
 
bbdobuddy said:
Hi,

I am appending text that I want to put in a text box but I want each group
of text I receive to be on its own line. What is the new line character
in
access?
Click to expand...

Chr(10) is a line feed and Chr(13) is a carriage return. You need both on a
PC
but on a Mac, Chr(13) is all you need. You can use either the vbCrLf or
vbNewLine
constant to do the same thing.

I prefer vbNewLine since it works on the Mac as well.

Tom Lake
 
Back
Top