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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Memo field 3
Memo Field Creation 4
Access Access 2003 Carriage Return Insertion 0
Popup a Memo field to add more data 4
Problem showing memo field in list box 3
Arranging text in a memo field 2
restrict memo field entry length 1
Only change font fomat in select words within a memo field 9

Top