Syntax for creating line feeds from VBA

[bhujanga]

I have a control box ([Comments]) bound to a memo field (also called 'Comments'). Based on certain things that change in the form , I want to add comments in there automatically from event code. I just need to know how to get each new comment to start on its own line.

Thanks.

 

[SkipVought]

hi.

Use vbLf whic is a line feed character.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[judgeh59]

Hey Skip - isn't there also a vbCrLf?

Ernest

Be Alert, America needs more lerts

 

[SkipVought]

Yes???

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Andrzejek]

You may also use good old [tt]vbNewLine[/tt]


Have fun.

---- Andy