Copying/Pasting into Update Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to copy and paste a five paragraph MS Word document into an update
query memo field. I keep getting the error message, "The text is too long to
edit." I can copy about 890 characters of the document into the query but no
more. I'm clearly doing or not doing something simple. Can anyone help?
 
Dear Bill:

Once you have a value stored in a column with 890 characters, what do you
expect to do with it functionally within a database? Would not a link to
the document work well? Would you ever have a much larger document
represented in this column?

Tom Ellison
 
Tom,

Thank you for replying. The database is a report card database that
includes a narrative. Within the narrative, the concept is to place global
descriptors of what was taught within each grade during the semester. The
idea is that after we in IT populate each report card with the descriptors,
the teachers would add comments where appropriate that would be specific to
the child being graded.

Late last night I discovered that I could copy the descriptors from Word and
paste them directly into the SQL, no matter how large the text, after which
query execution runs fine. This just seems to be an awkward way of doing it.
I'm now wondering if our report card system is becoming too complex for
Access.

Thanks again.
 
Back
Top