Copying and pasting into a memo field - how can I split at line breaks?

[Jeremy]

I have a pretty straightforward database that is designed to record
free-form information about products (date, source and a memo field).
This is searched and updated via a form. For new records, the memo
field is usually filled by cutting and pasting from e-mails, web
content and spreadsheets.

The only problem is that some of the memos can be just a few words,
and some can be tens or hundreds of lines, and I've realised that
zooming matching fields one by one is very tedious!

Ideally I'd like to make the form detect multiple line memo fields,
and break them up so that it enters into the database a number of
fields with the same [date] and [source] but successive memo fields.

I'm guessing that this needs some Visual Basic, but believe it or not
I've built this database (which also includes sales history lookups
from our accounting system and a few other bits and pieces) without
once touching VB. By painful trial and error I have worked out how to
spot the line breaks by the CHR$(13), so I can successfully edit the
current record to include just the first line of text, but I just
can't work out how to create all the other records.

Can this be done without too much code, or am I barking up the wrong
tree? I started out by trying to make an input form or sheet that
would behave like Excel and interpret the line breaks in the pasted
text as separate records, but I'm 99% convinced that the memo field
logic prevents this.

Any advice will earn my undying thanks!
Jeremy

[John Sheppard]

I cant figure out what your trying to do, Perhaps a continuous form as a
subform would help you?
What do you mean 'zooming matching fields'?

Are you wanting to edit the data from the clipboard as it is pasted? or are
you wanting to edit the data that is already in the existing tables?

"Jeremy" <no****@brall.c o.uk> wrote in message
news:92******** *************** ***@posting.goo gle.com...

I have a pretty straightforward database that is designed to record
free-form information about products (date, source and a memo field).
This is searched and updated via a form. For new records, the memo
field is usually filled by cutting and pasting from e-mails, web
content and spreadsheets.

The only problem is that some of the memos can be just a few words,
and some can be tens or hundreds of lines, and I've realised that
zooming matching fields one by one is very tedious!

Ideally I'd like to make the form detect multiple line memo fields,
and break them up so that it enters into the database a number of
fields with the same [date] and [source] but successive memo fields.

I'm guessing that this needs some Visual Basic, but believe it or not
I've built this database (which also includes sales history lookups
from our accounting system and a few other bits and pieces) without
once touching VB. By painful trial and error I have worked out how to
spot the line breaks by the CHR$(13), so I can successfully edit the
current record to include just the first line of text, but I just
can't work out how to create all the other records.

Can this be done without too much code, or am I barking up the wrong
tree? I started out by trying to make an input form or sheet that
would behave like Excel and interpret the line breaks in the pasted
text as separate records, but I'm 99% convinced that the memo field
logic prevents this.

Any advice will earn my undying thanks!
Jeremy

[Jeremy]

"John Sheppard" <jt************ @nobosospam.com .au> wrote in message news:<3f******* *************** *@news.optusnet .com.au>...

I cant figure out what your trying to do, Perhaps a continuous form as a
subform would help you?
What do you mean 'zooming matching fields'?

Are you wanting to edit the data from the clipboard as it is pasted? or are
you wanting to edit the data that is already in the existing tables?

John

I use the memo field for a search, which shows 3 lines of the memo.
By 'zooming matching fields' I mean tabbing through the matches and
hitting the zoom key. This isn't very satisfactory, especially as it
means the users have to remember the part number they're searching
for.

I need both to update the existing data, and find a way to
automatically amend data on input. My ideal solution would be to have
the input subform, just before update, check the memo field for
multiple lines and if found turn these into multiple records (with all
other fields the same except the autoid primary key of course).

Jeremy