Why i can't export a memo field with a query?

  • Thread starter Thread starter Juan Padilla via AccessMonster.com
  • Start date Start date
J

Juan Padilla via AccessMonster.com

I'm trying to exporta memo field from a form to a table, and the query only export a part and the rest is lost. Somebody can tell me what can i do? Thanks
 
What code/query setup are you trying to use?


Juan Padilla via AccessMonster.com said:
I'm trying to exporta memo field from a form to a table, and the query
Click to expand...
only export a part and the rest is lost. Somebody can tell me what can i do?
Thanks
 
I'm trying to exporta memo field from a form to a table, and the query only export a part and the rest is lost. Somebody can tell me what can i do? Thanks
Click to expand...

Remove any Format that you've applied to the memo field; if you're
using a query, be sure that you're not sorting or grouping by the memo
field. Any Format or sort applied to a Memo truncates it to 255 bytes.

John W. Vinson[MVP]
 
Back
Top