Putting a line break into a memo box 1

[telephoto]

When adding an item to a contract, the item's "notes" memo field is amended.

I want to start a fresh line in the text box, hence the code:

 txtNotes = txtNotes & vbLf & "This machine added to contract " & CurrentContract & "on " & Left(Now, 10)

The comment is added, but without a fresh line.

Please can someone tell me how to do that?

Thank you
T

 

[PHV]

Try to replace vbLf with either vbCr or vbCrLf

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Andrzejek]

PHV suggestion will work, but I am lazy and all I remember for a new line is... [tt]vbNewLine:

txtNotes = txtNotes & vbNewLine & "This machine added to contract " & CurrentCon
[/tt]


Have fun.

---- Andy

 

[dhookom]

Although I am also lazy, I typically use an expression that works in vba and a query/control source.

txtNotes = txtNotes & Chr(13) & Chr(10) & "This machine added to contract " & CurrentCon

Duane
Hook'D on Access
MS Access MVP