[AccessD] Exporting Memo Field

Bob,

I don't think that you should have to use InStr(). Replace() would work a
lot better, IMO.

Arthur


On Wed, Jan 22, 2014 at 2:28 PM, Bob Heygood <accesspro at gmail.com> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Arthur