[AccessD] Exporting Memo Field

You can export memo fields, but the query engine has lots of sand traps
around memo fields.  If you try to sort on a memo or filter on it, you will
get a truncated field in the export.

Charlotte


On Sun, Jan 19, 2014 at 9:59 PM, doug <dw-murphy at cox.net> wrote:

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