The text is too long to be edited

[Paul]

I tried to copy and paste into a defined memo field in an
access table, and get the following message. "The text is
too long to be edited". it has nothing to do with MS KB
article 322874. does memo fields have a max length, and
what is it, and how can it be changed, if it can. Or why
am I getting is messages, I'm copying html from MS
Frontpage to a memo field. I've copied appending parts
and see that its a size or space problem of that memo
field. Have I reached the max.

 

[Joe Fallon]

65,535 charaters is the max.

 

[Tim Ferguson]

65,535 charaters is the max.

But this is the limit imposed by the text box, not by the memo field..


Tim F

 

[Joe Fallon]

From A97 Help:

Use the Memo data type if you need to store more than 255 characters. A Memo
field can store up to 64,000 characters. Memo fields can't be indexed or
sorted.

I always thought the 64,000 was a rough number and that the real number was
65,535 (a power of 2 -1).
Guess it really is just 64,000.

 

[Tim Ferguson]

I always thought the 64,000 was a rough number and that the real
number was 65,535 (a power of 2 -1).
Guess it really is just 64,000.

Also from the help file (this a A2000, but memory (!) suggests it was the
same in A97):

Up to 65,535 characters. (If the Memo field is manipulated through DAO and
only text and numbers [not binary data] will be stored in it, then the size
of the Memo field is limited by the size of the database.)


Certainly this routine works without problem and saves a 100K memo field.

strLarge = String(1024, "*") ' One KByte

' open recordset here...

rs!memofield = ""

For dwCounter = 1 To 100
rs!memofield.AppendChunk strLarge
Next dwCounter

MsgBox "Chars = " & Str(Len(rs!memofield)) ' Returns 102,400

rs.Update


but it does refuse to be edited by clicking on the datasheet textbox...
That's what I meant by it being a UI limit rather than a Jet limit.

All the best


Tim F

 

[Joe Fallon]

Thanks! Didn't know that difference existed.
I *knew* I had seen the 65,535 someplace!
--
Joe Fallon
Access MVP

I always thought the 64,000 was a rough number and that the real
number was 65,535 (a power of 2 -1).
Guess it really is just 64,000.

Also from the help file (this a A2000, but memory (!) suggests it was the
same in A97):

Up to 65,535 characters. (If the Memo field is manipulated through DAO and
only text and numbers [not binary data] will be stored in it, then the size
of the Memo field is limited by the size of the database.)


Certainly this routine works without problem and saves a 100K memo field.

strLarge = String(1024, "*") ' One KByte

' open recordset here...

rs!memofield = ""

For dwCounter = 1 To 100
rs!memofield.AppendChunk strLarge
Next dwCounter

MsgBox "Chars = " & Str(Len(rs!memofield)) ' Returns 102,400

rs.Update


but it does refuse to be edited by clicking on the datasheet textbox...
That's what I meant by it being a UI limit rather than a Jet limit.

All the best


Tim F