doug
dw-murphy at cox.net
Sun Jan 19 23:59:05 CST 2014
Not sure I understand. I put memo field contents into string variables and work with them. Thought the only limit was on text fields. -------- Original message -------- From: Bob Heygood <accesspro at gmail.com> Date:01/19/2014 8:04 PM (GMT-08:00) To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com> Subject: [AccessD] Exporting Memo Field Hello to the Group, I need to manipulate some text which in memo fields. When I try to parse it in VBA, I seem only to be able to access the first 255 chars. I thought that I had solved the problem by copying the whole table to Word. I know this sounds funny, but it worked. It pasted into Word in the form of a Word table. I thought that then it should easy to copy back into Access, or into Excel and then into Access. The latter seemed to work. But when I started to process the newly created table that I pasted into from Excel, I discovered that again I only had the first 255 chars. How can I "access" this data? TIA, Bob Heygood -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com