Convert memo field to multiple text fields

[hertfordkc]

In 2002, I set up a database with Access 97 which included a table with a memo field. Through the years, the database has moved from Windows XP and Access 97 to Windows 7 and Access 2007.


Recently, the memo data has been difficult to edit (the display will move away from the cursor, or a new record will be inserted). Posts and searches of this forum and others have not yielded a solution nor an explanation of why it has happened.
It appears to be logically straightforward to convert the memo data into multiple text fields as the memo field can be parsed for dates of entry. Can someone share the technique or VB to do this?

TIA

[June7]

Can use string manipulation functions to parse text. Consistency of structure is critical. What would be searched for in the string that would indicate a break?

[hertfordkc]

Each memo field is associated with an unique account number. Within the field, each entry usually contains a date within 255 characters.
Would substring parse beyond 255 characters? My reading of the documentation suggests that text operations on the MEMO field aren't possible. In other words, I see how to break up the first 255 characters, but don't see what to do beyond that.

[hertfordkc]

Thanks, June7.
I dared to try the string functions on the memo field and they do work. I'll work out a routine to convert the memo fields to text fields.