If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
The text is too long to be edited
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 |
#4
|
|||
|
|||
The text is too long to be edited
|
#5
|
|||
|
|||
The text is too long to be edited
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 |
#6
|
|||
|
|||
The text is too long to be edited
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 |
#7
|
|||
|
|||
The text is too long to be edited
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 |
#8
|
|||
|
|||
The text is too long to be edited
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 |
#9
|
|||
|
|||
The text is too long to be edited
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 |
Thread Tools | |
Display Modes | |
|
|