Combine fields Text to Memo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top