 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / May 2008The 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 >I created a new Access database using Access 2002 SP3 > [quoted text clipped - 16 lines] > >Charles W 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 > > 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.  SignatureRick 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 >Chris > [quoted text clipped - 10 lines] >>> >>>Charles W 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 [quoted text clipped - 23 lines] > >>> > >>>Charles W 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. 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 > Good point. > [quoted text clipped - 5 lines] >>may >>look empty but not really be empty. 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.... > [quoted text clipped - 31 lines] >>>may >>>look empty but not really be empty. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.