Bob Heygood
accesspro at gmail.com
Wed Jan 22 13:28:47 CST 2014
Jim, Doug, Charlotte and William Thanks for the info. I also spent some time looking at the link to Allen's site, good stuff. It looks like a lot of my problems have to do with the LFCRs in my memo field. Should I not be able to check for and locate them with the instr() ?? Should the mid() function function correctly when LFCR is part of said string ? TIA again, Bob Heygood -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Monday, January 20, 2014 9:13 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Exporting Memo Field Bob, Here's a good listing (old, but still good) of all the in's and out's with memo fields and truncation: http://allenbrowne.com/ser-63.html Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood Sent: Sunday, January 19, 2014 11:05 PM To: 'Access Developers discussion and problem solving' 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com