[AccessD] Memo field is truncated

Dan Waters dwaters at usinternet.com
Tue Feb 10 15:01:59 CST 2009


Hi Susan,

Look for some kind of DISTINCT query or recordset.  If a memo field is
included, it will be truncated.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, February 10, 2009 2:53 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Memo field is truncated

I've seen this discussed many times, but I can't remember the solution -- a 
reader's Make Table query is truncating a Memo field to 255 characters. I've

found a few things on the kb, but nothing that seems to be the exact thing 
I'm looking for -- nothing for Make Table anyway. I've sent links to the few

articles that are close.

Does anyone remember what this is -- off the top of your head?

Susan H. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list