Populating a memo field in a table

G

Guest

I am trying to combine text from a number of different records into a single
memo style field on a table. I can combine the text ok by cycling through the
records (they have a common piece of data that associates them) and
concatenating the relevant text fields, but I want to add the text from each
record on a new line in the memo field.

So for example, if was trying to combine 3 records with text of 'AA', 'BB'
and 'CC' respectively, I end up with:
AABBCC
instead of:
AA
BB
CC
 
G

Guest

You say that you're cycling through the text fields. How are you doing this?

I only ask, because you can insert a carriage return between entries:

myValue = Me.txtOne & vbCrLf & Me.txtTwo

etc...

idea...?
 

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

Text and Memo field concatenation - Line break (Access 2007) 4
combining 2 queries (union) causes field to be truncated 3
Changing a 1 Row Table to 2 Column Table 3
Formatting Memo Field Text 4
Only change font fomat in select words within a memo field 9
Text to Memo 1
Relate words in memo/text field to another table 1
Memo Field needs to include field name within field. 7

Top