Re: Copying/Pasting into Update Query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Tom Ellison" <tellison@xxxxxxxxxxx>
Date: Tue, 10 Jan 2006 19:42:08 -0600

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

"Bill M" <BillM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:665AAFDF-7661-408C-9D42-5E95CA2DC2A8@xxxxxxxxxxxxxxxx
> 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?

.

Prev by Date: Re: Query Help
Next by Date: Re: Help! Help! Help!
Previous by thread: Selection criteria and Group by
Next by thread: Re: How do I set up a parameter query using a combo box in Access?
Index(es):
- Date
- Thread

Relevant Pages

RE: Repost - RunTime Error - Field too small
... Jet won't store changes to the external database in the table ... Here is the DLookup statement in the AfterUpdate event of the FacilityNumber ... If the name is longer that 30 characters, I get the error message. ...
(microsoft.public.access.formscoding)
RE: Repost - RunTime Error - Field too small
... Jet won't store changes to the external database in the table ... post your DLookup() code and example data that ... I get an error message and I cannot ... > It seems to die if the field has more than 30 characters. ...
(microsoft.public.access.formscoding)
Re: non SGML character escape
... If the validation fails, kick it back to the user with a big ... red X and the error message "No dice." ... Even though the database ... Some of the characters are not being escaped.... ...
(comp.lang.java.programmer)
Passwords
... I have a password field in a database. ... user can only type in 7 characters for a password. ... more an error message will appear? ...
(microsoft.public.access.formscoding)
Re: Loading a data file containing character fields with different encodings
... The data is coming from one database that contains UTF-8 characters and it appears that he's attempting to load ... UTF-8 characters along with Latin-1 characters. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ...
(comp.databases.informix)