What is vbCrLf???

[syedshaffee]

Hey people,

Can some give me a simple explanation on

vbCrLf

I Don't exactly known what it is used for

[TheSmileyCoder]

It stands for
vb: Visual Basic
Cr: Carriage Return
Lf: LineFeed

In the ole days of typewriters the carriage return means to move the carriage all the way back left.
Linefeed simply is to push the paper in the typewriter up a line, giving a new blank line.

For a bit more Detail:

vbCrLf = vbNewLine = chr(13) & chr(10)

On a interesting note you will find that Excel uses only chr(10) instead of the combination of the chr(13) and chr(10). I have on occasion when moving data back and forth between the Access and excel depending on how its done had to do a search and replace to get the conversion right.

[syedshaffee]

TheSmileyCoder You ROck???

[TheSmileyCoder]

Thank you for those kind? words :)