[AccessD] Exporting Memo Field

I should have been more clear. I don't need to replace the vbLFCRs, I needed
locate them.

And I have since found instr() to be able to locate the vbLFCR.
My challenge now is to do some manipulation of these memo "strings" in vba
using the vbLFCRs to know how to parse the data.
mid() & pos() are my friends....


Thanks again to all who responded.

Bob Heygood 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Thursday, January 23, 2014 7:47 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com