By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,972 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,972 IT Pros & Developers. It's quick & easy.

Text is too long to be edited

P: n/a
JA
Why do I sometimes get the error "the text is too long to be edited" when
trying to work directly in a memo field in Access 2000?

Is there a way to make that go away?

Thanks, JA
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
JA wrote:
Why do I sometimes get the error "the text is too long to be edited" when
trying to work directly in a memo field in Access 2000?

Is there a way to make that go away?

Thanks, JA

I often wonder why people post messages without an error number, only
the error description. I guess those folks think we have all
experienced every error that exists in Access and have them memorized

Having said that, are you sure you are really working with a memo? Open
up the table and verify it is not a text field. A field can't contain
more than 255 characters.

Perhaps your memo is huge. Under Access Specifications in help, it
states "65,535 when entering data through the user interface;
1 gigabyte when entering data programmatically." Maybe you can do a
Len(MemoField) to see how large it is.

Nov 13 '05 #2

P: n/a
JA
There was no error number, only "Text is too long to be edited".
Yes, I'm sure it's a memo field. And there's a lot of characters in there,
but not over the 65,535 limit.

Thanks, JA


"Salad" <oi*@vinegar.com> wrote in message
news:C%*****************@newsread3.news.pas.earthl ink.net...
JA wrote:
Why do I sometimes get the error "the text is too long to be edited" when
trying to work directly in a memo field in Access 2000?

Is there a way to make that go away?

Thanks, JA

I often wonder why people post messages without an error number, only the
error description. I guess those folks think we have all experienced
every error that exists in Access and have them memorized

Having said that, are you sure you are really working with a memo? Open
up the table and verify it is not a text field. A field can't contain
more than 255 characters.

Perhaps your memo is huge. Under Access Specifications in help, it states
"65,535 when entering data through the user interface;
1 gigabyte when entering data programmatically." Maybe you can do a
Len(MemoField) to see how large it is.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.