[AccessD] Exporting Memo Field

Bob,

Was just about to put the same as arthur, i think i used to do something
like replace(yourstring, replace(yourstring, chr(13), ""), chr(10), "")
 (hope I haven't mixed VBA with SQL there but sure it was something like
that.

Paul


On 23 January 2014 15:46, Arthur Fuller <fuller.artful at gmail.com> wrote:

> 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
>



-- 
Paul Hartland
paul.hartland at googlemail.com