Carriage Return in memo field.

[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

 

[Dirk Goldgar]

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

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"