Access 2000 - How to Generate Multiline Strings in a Memo field...

J

Jamdee

I am using Access 2K and need to generate multiline strings within a memo
field via VB code. Where you would click a button and it would first move to
a new line within the field, then add the following format of text:
Line 1
Line 2
Line 3 and so on...
 
B

Brendan Reynolds

'first add new line only if text box is not empty
If Len(Me.SomeTextBox & vbNullString) > 0 Then
Me.SomeTextBox = Me.SomeTextBox & vbCrLf
End If
Me.SomeTextBox = MeSomeTextBox & "Line 1" & vbCrLf & "Line2" & vbCrLf &
"Line 3" 'etc
 
Top