Multiple Fields in one memo field

[Elsw]

Hi Guys,

Can anyone tell me how I can add multiple fields in to one Memo field that each on it on a new line on a form.
I Know i can =[field1] & " " & [field2] & " " & [field3]
But how do i add them that they come out on the memo field like this

Field1
Field2
Field3

I need them this way to be able to send them in an email.
I cannot make it in a report as the power that be do not want the info emailed to them as an attachment.

 

[Trevor G]

Welcome to the forum,

I would use a query and create an Expression to get the mutliple lines.

An example would be like this

3 Lines: IIf([Field1] Is Not Null,[Field1] & Chr(13) & Chr(10),Null) & IIf([Field2] Is Not Null,[Field2] & Chr(13) & Chr(10),Null) & IIf([Field3] Is Not Null,[Field3] & Chr(13) & Chr(10),Null)

 

[boblarson]

Hi Guys,

Can anyone tell me how I can add multiple fields in to one Memo field that each on it on a new line on a form.
I Know i can =[field1] & " " & [field2] & " " & [field3]
But how do i add them that they come out on the memo field like this

Field1
Field2
Field3

I need them this way to be able to send them in an email.
I cannot make it in a report as the power that be do not want the info emailed to them as an attachment.

A common mistake is for people to believe that they can only do emails, reports, etc. from a table. You can use a query like Trevor has suggested and that is the way to go here. Just for your information you can use a query where you would use a table in probably 99% of the places.