The text is too long to be edited

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

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


wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200805/1

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


"Chris O'C via AccessMonster.com" u29189@uwe wrote in message
news:84ab149b50101@uwe...
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


wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200805/1

wrote:
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.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot 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


wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200805/1

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.

"Chris O'C via AccessMonster.com" wrote:

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


wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200805/1

Good point.

Chris
Microsoft MVP


Fred wrote:
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.

--
Message posted via http://www.accessmonster.com

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 a
BookID (Autonumber, Key}
OldBookNo (Text)
BookNo (Text)
Title (Text, fieldd size 200)
Date (Text)
Location (text)


Thanks for your help.

Charles W


"Chris O'C via AccessMonster.com" u29189@uwe wrote in message
news:84c9c569d8bad@uwe...
Good point.

Chris
Microsoft MVP


Fred wrote:
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.

--
Message posted via http://www.accessmonster.com

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

" wrote in message
et...
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 a
BookID (Autonumber, Key}
OldBookNo (Text)
BookNo (Text)
Title (Text, fieldd size 200)
Date (Text)
Location (text)


Thanks for your help.

Charles W


"Chris O'C via AccessMonster.com" u29189@uwe wrote in message
news:84c9c569d8bad@uwe...
Good point.

Chris
Microsoft MVP


Fred wrote:
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.

--
Message posted via http://www.accessmonster.com