[AccessD] difference between linefeed and carriage return

An excuse to plug my fave text editor of all time: NoteTab can handle *nix files just fine, and save them to CRLF-style files if you want, or preserve their *nix format.

For my money (ironic, since the basic NoteTab is free), the coolest feature is that you can open a dozen files then exit the program, and when you re-enter all the files are loaded, with the cursor just where you left it in each case.

Arthur

----- Original Message ----
From: Gustav Brock <Gustav at cactus.dk>
To: accessd at databaseadvisors.com
Sent: Sunday, December 10, 2006 3:38:45 AM
Subject: Re: [AccessD] difference between linefeed and carriage return

Hi Susan

Further to Bruce's explanation, note that the sequence always must be CR+LF in the DOS and Windows world. That means Chr(13) & Chr(10) which can be hard to remember even if you use the constant vbCrLf. And in SQL the constant cannot be used, so you have to learn.

To simplify things, MS introduced the "clear language" constant vbNewLine which in Windows equals vbCrLf but is easier to remember.

What complicates matters is that the Unix and Linux world uses only a LF for a new line while the old Mac OS used CR only. This means that a text file created in Unix or an old Mac may - when viewed in Windows - not display as intended.

More fun here:

  http://en.wikipedia.org/wiki/Newline

/gustav