The text is too long to be edited

[charles]

I created a new Access database using Access 2002 SP3

I made a table and a text field with field size 200

When I try to paste text into this field I get an error message
"The text is too long to be edited"

There is no error number, only a message box with this message.

I have tried everything but the field will not accept a string longer than
50 Chars.

I have even checked for invalid ASCII characters,
there are none, and the field is not linked to any source.

Can anyone tell me why this is happening and what I can do to fix it.


Thanks.

Charles W

 

[Chris O'C via AccessMonster.com]

The record length you're trying to store might exceed what will fit on a data
page. A data page is 4 KB for Jet 4.0 or 2K for Jet 3.5. The data page
includes the page definition and row definitions so you can only fit about 4,
000 bytes of data per record in Jet 4.0.

Chris
Microsoft MVP

 

[charles]

Chris

I am nowhere near that limit.

I cannot type or paste more than 50 characters into the field
event thought the field size is 200

Charles W

 

[Rick Brandt]

Chris

I am nowhere near that limit.

I cannot type or paste more than 50 characters into the field
event thought the field size is 200

Possibility 1: The field size is not what you think it is.

Possibility 2: What you are pasting is longer than you think it is.

Where did you copy or cut this data from? It might include additional
non-printing) characters that you cannot see, but which will be included in
the paste.

Did you copy a row from another table or query? A common mistake in that
regard is not realizing that the column counts are different or that the
order of the columns is not the same.

 

[Chris O'C via AccessMonster.com]

Name all of your column names and their data types in the table and list them
in your next post. For each text field, include the field size and whether
it's using compression.

Is the table using Access 2000 database format or newer, or is it using an
earlier version of Access? The db format will show in the title bar of the
db window, but if it's a linked table that won't tell you which db format it
is. You'll have to open the db file the table is in to find that table's db
format.

Chris
Microsoft MVP

Chris

I am nowhere near that limit.

I cannot type or paste more than 50 characters into the field
event thought the field size is 200

Charles W

The record length you're trying to store might exceed what will fit on a
data

[quoted text clipped - 26 lines]

 

[Fred]

One more thought. make sure the target field is really empty. (Shift-F2)
Sometimes when there is a line break or something, on a small display it may
look empty but not really be empty.

Name all of your column names and their data types in the table and list them
in your next post. For each text field, include the field size and whether
it's using compression.

Is the table using Access 2000 database format or newer, or is it using an
earlier version of Access? The db format will show in the title bar of the
db window, but if it's a linked table that won't tell you which db format it
is. You'll have to open the db file the table is in to find that table's db
format.

Chris
Microsoft MVP

Chris

I am nowhere near that limit.

I cannot type or paste more than 50 characters into the field
event thought the field size is 200

Charles W

The record length you're trying to store might exceed what will fit on a
data

[quoted text clipped - 26 lines]

Charles W

 

[Chris O'C via AccessMonster.com]

Good point.

Chris
Microsoft MVP

One more thought. make sure the target field is really empty. (Shift-F2)
Sometimes when there is a line break or something, on a small display it may
look empty but not really be empty.

 

[charles]

Thanks for your comments....

It was when I tried to paste the text from Excel that I got the
message. I then checked the ASCII values of all the characters
but found nothing that shouldn't be there.

I then tried to type into the field and it would only accept 50 characters.
I increased the text field size from 100 to 200 and then 255 but it made no
difference.

I'm using Microsoft Access 2002 with SP3.

The field names are:
BookID (Autonumber, Key}
OldBookNo (Text)
BookNo (Text)
Title (Text, fieldd size 200)
Date (Text)
Location (text)


Thanks for your help.

Charles W

 

[Jeanette Cunningham]

Charles,
Create a new text field, call it NewTitle.
Make NewTitle a memo field. Use this as a way to check how many characters
are being pasted.

Does the same thing happen?


Jeanette Cunningham -- Melbourne Victoria Australia

Thanks for your comments....

It was when I tried to paste the text from Excel that I got the
message. I then checked the ASCII values of all the characters
but found nothing that shouldn't be there.

I then tried to type into the field and it would only accept 50
characters.
I increased the text field size from 100 to 200 and then 255 but it made
no difference.

I'm using Microsoft Access 2002 with SP3.

The field names are:
BookID (Autonumber, Key}
OldBookNo (Text)
BookNo (Text)
Title (Text, fieldd size 200)
Date (Text)
Location (text)


Thanks for your help.

Charles W