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

  • Thread starter Juan Padilla via AccessMonster.com
  • 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
 
R

Rob Oldfield

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
 
J

John Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Images are pixelated when saving to PDF 0
pasting unwanted data 0
VBA - exporting serial letters to single documents 0
Restoring line breaks in memo field 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Notes table and IndirectDataInput / Date stamp in Memo field 3
Setting a default zoom in Infopath 0
DLookup in Continuous form 0

Top