Combine fields Text to Memo

B

Buddy

I am combining 8 text fields into one memo field using a query. After each
field I want a line feed so that each text field will be on a separate line
in the memo, but I don't know the syntax. Any help will be appreciated.
the query line looks like:
x:F001 & F002 & F003 etc.

Thanks
 
S

stumac

Chr(13) & Chr(10)&[F001]& Chr(13) & Chr(10)&[F002]&Chr(13) & Chr(10)&[F003]

this will put them each on to a new line.

Stu
 

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

Grow/Shrink Text gradually from slide to slide 0
Template with fields and premade texts.. 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Possible to Combine reports to's to a single box? 0
Memo fields not displaying in query 4
disctinct query memo field 3
Combining three files when middle file has sections with endnotes 2
Finding the right style field in VBA 0

Top