Carriage Return in memo field.

1

111

i have created a form which populates the to/from/subject/memo lines of an email and it works
fine. the problem is the memo field would look better if i could put the information underneith
eachother instead of beside.
Can someone show me how to do the carriage return so the data looks like this

line data 1
line data 2
line data 3

instead of:

line data 1 line data 2 line data 3



my code is as follows:



MessageText:="This shipment has been confirmed picked up today" & " " & [shipREADY DATE] & " and
will arrive for delivery " & [Text84] & " Shipper / De: = " & [Text200] & " " & "Consignee
/ = " & [Text202] & " " & "Carrier / Transportista = " & [Text204] & " " & "FTL/LTL
= " & [Text220] & " " & "In Bond = " & [Text225] & " " & "Freight Charges / Flete = "
& "$ " & [MX Details sell rate] & [MX Details Sell Curr] & " " & "Trailer # = " & [Text198]
& " " & " ETA " & [Text84], _

your assistance is greatly appreciated.
Steve
 
D

Dirk Goldgar

111 said:
i have created a form which populates the to/from/subject/memo lines
of an email and it works fine. the problem is the memo field would
look better if i could put the information underneith eachother
instead of beside.
Can someone show me how to do the carriage return so the data looks
like this

line data 1
line data 2
line data 3

instead of:

line data 1 line data 2 line data 3



my code is as follows:



MessageText:="This shipment has been confirmed picked up today" & " "
& [shipREADY DATE] & " and will arrive for delivery " & [Text84] & "
Shipper / De: = " & [Text200] & " " & "Consignee / = " &
[Text202] & " " & "Carrier / Transportista = " & [Text204] & "
" & "FTL/LTL = " & [Text220] & " " & "In Bond = " & [Text225] &
" " & "Freight Charges / Flete = " & "$ " & [MX Details sell
rate] & [MX Details Sell Curr] & " " & "Trailer # = " &
[Text198] & " " & " ETA " & [Text84], _

your assistance is greatly appreciated.
Steve
Click to expand...

Wherever you want a line break to occur, concatenate the defined
constant vbCrLf (or vbNewLine, which is the same thing, or the
combination Chr(13) & Chr(10), which is also the same thing). For
example,

MessageText:= _
"Line 1 data" & vbCrLf & _
"Line 2 data" & vbCrLf & _
"Line 3 data"
 

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

Code to add a carriage return to a memo field in a form 3
Replace Carriage Return ASCII Character in Memo Field 3
Find Last instance of carriage return In a Memo Field 2
Carriage return in memo field 2

Top