DataBase - The text is too long to be edited

Asked By charle

24-May-08 07:37 PM

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

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

25-May-08 03:15 AM

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



--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200805/1

25-May-08 07:10 AM

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

25-May-08 08:03 AM

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

25-May-08 09:50 AM

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



--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200805/1

27-May-08 10:03 AM

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.

27-May-08 01:50 PM

Good point.

Chris
Microsoft MVP



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

28-May-08 09:45 AM

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

28-May-08 06:45 PM

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