Make table query truncating a field

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have a "make table" query that uses an expression that makes a very
lengthy "Notes" field. When the query makes the new table, it automatically
formats the field as a regular text field instead of a memo field. Because
of this, my data is truncated. Is there a way to tell the query to make the
Notes field as a memo?
 
Hi Todd

I would change the the query to an append query. Of course, you would have
to create a table first with the desired structure (i.e. this way you can
control which fields need to be of Memo type).

HTH,
Immanuel Sibero
 
That seemed like a great idea, but I still have the same problem with the
Append Query. I formatted the database to have "Notes" set as a memo, but
it is still truncated. Any other suggestions?
 
Back
Top