Merging multiple Text fields into one Memo field

  • Thread starter Thread starter Cheryl Fischer
  • Start date Start date
I have inherited a database at work that has a notes box on a form. However,
instead of being a single Memo field, the notes is actually 8 separate text
fields, Notes1, Notes2.... etc. I would like to merge all these separate
text fields into a single memo field. I know how to run an update query to
merge them using the & sign to join two strings together, but how can I
force a carriage return (new line) after each field has been joined, so that
each text field would have it's own line in the resulting memo box on a
form? I would be grateful for any help. Jacko
 
You're welcome and happy holidays to you.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Jacko said:
Thanks Cheryl. I just did a test and your solution worked like a dream.
Happy Christmas. Jacko.

Cheryl Fischer said:
Try ...

[Notes1] & Chr(13) & Chr(10) & [Notes2] & Chr(13) & Chr(10) & etc.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Jacko said:
I have inherited a database at work that has a notes box on a form. However,
instead of being a single Memo field, the notes is actually 8 separate text
fields, Notes1, Notes2.... etc. I would like to merge all these separate
text fields into a single memo field. I know how to run an update
Click to expand...
Click to expand...
query
to so
that
Click to expand...
Click to expand...
 
Thanks Cheryl. I just did a test and your solution worked like a dream.
Happy Christmas. Jacko.

Cheryl Fischer said:
Try ...

[Notes1] & Chr(13) & Chr(10) & [Notes2] & Chr(13) & Chr(10) & etc.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Jacko said:
I have inherited a database at work that has a notes box on a form. However,
instead of being a single Memo field, the notes is actually 8 separate text
fields, Notes1, Notes2.... etc. I would like to merge all these separate
text fields into a single memo field. I know how to run an update query to
merge them using the & sign to join two strings together, but how can I
force a carriage return (new line) after each field has been joined, so that
each text field would have it's own line in the resulting memo box on a
form? I would be grateful for any help. Jacko
Click to expand...
Click to expand...
 
Back
Top