Data too long

[Guest]

Hi, I have a memo field to update with a description that is approximately
3,00 characters in length. I created a select query to return the records
that need to be updated and I manually pasted the dexcription directly into
the query results. However, when I review what I just pasted I find it has
been truncated. I tried turning the select query into a update query and get
a message back stating the "string returned by the builder was too long and
the result will be truncated." I went to from the update query design grid
view to the update query SQL view, pasted my long description, and it appears
the descriptions were updated successfully. However, when I tried going from
SQL to design grid with the longer description, I got a message back stating
teh "1,024 character limit for query design grid was exceeded". Can someone
tell me where in regedit this limit is located? Can someone also tell me if
using SQL is the best way to update the empty description fields with the
long description? Thanks.

Andrew

 

[John Vinson]

Hi, I have a memo field to update with a description that is approximately
3,00 characters in length. I created a select query to return the records
that need to be updated and I manually pasted the dexcription directly into
the query results. However, when I review what I just pasted I find it has
been truncated. I tried turning the select query into a update query and get
a message back stating the "string returned by the builder was too long and
the result will be truncated." I went to from the update query design grid
view to the update query SQL view, pasted my long description, and it appears
the descriptions were updated successfully. However, when I tried going from
SQL to design grid with the longer description, I got a message back stating
teh "1,024 character limit for query design grid was exceeded". Can someone
tell me where in regedit this limit is located? Can someone also tell me if
using SQL is the best way to update the empty description fields with the
long description? Thanks.

Andrew

This cannot be overridden. If you want to just change the value of a
portion of a Memo field, e.g. replace "Green" with "Red" anywhere in
the memo, you can use the Replace() function rather than reentering
the entire contents of the field.

But... could you post the SQL view of your query?

John W. Vinson[MVP]