Make Table query Memo field

  • Thread starter Thread starter FPSC
  • Start date Start date
F

FPSC

I have a SQL query that make a table with a very long text on one column.
When I run the query without making the table the text is complete, but when
I Make the Table the field appear truncated to 255 characters.

I need to keep that column as a Memo not as a text, so all the characters
are kept and not truncate to 255.

What is the code to do that?

Any help will be appreciated.

Thank you.
 
Hi,

Memo fields are troublesome at times. A quick fix would be to make a
table in advance and change your make-table query to an append query. This
should maintain the length of your field.
 

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

Make Table Query Truncating Memo Field at 255 Characters 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Query field size quandry 2
disctinct query memo field 3
Memo Field is truncated 5
Force data type from Text to Memo in a simple Make Table Query 1
Query Truncating Memo Field 9
How can I convert text field to memo field in a query 10

Back
Top