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
|
|||
|
|||
"field too small to accept amount of data you attempted to add" er
Error: The field is too small to accept the amount of data you attempted to
add. Try inserting or pasting less data. I have a text degree field set to default 50 chars. My form has a combo box that permits a user to select from the list or add using NotInList. There is also a separate maintenance form to permit the user to add degrees. I get the error if I try to add a 6-char degree in the combo box. So I added the 6-char degree using the maintenance form successfully. However, when I try to select that degree using the combo box I get the error. There appears to be ample room in the combo box to handle more than 6 chars. Any ideas? TIA, Gin |
#2
|
|||
|
|||
"field too small to accept amount of data you attempted to add" er
I just noticed the combo box doesn't permit more than 4 chars???? It stops
after 4-chars and asks if I want to add it to the list. Gin "GinTonic" wrote: Error: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. I have a text degree field set to default 50 chars. My form has a combo box that permits a user to select from the list or add using NotInList. There is also a separate maintenance form to permit the user to add degrees. I get the error if I try to add a 6-char degree in the combo box. So I added the 6-char degree using the maintenance form successfully. However, when I try to select that degree using the combo box I get the error. There appears to be ample room in the combo box to handle more than 6 chars. Any ideas? TIA, Gin |
#3
|
|||
|
|||
"field too small to accept amount of data you attempted to add" er
On Thu, 15 Feb 2007 15:31:10 -0800, GinTonic
wrote: Error: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. I have a text degree field set to default 50 chars. My form has a combo box that permits a user to select from the list or add using NotInList. There is also a separate maintenance form to permit the user to add degrees. I get the error if I try to add a 6-char degree in the combo box. So I added the 6-char degree using the maintenance form successfully. However, when I try to select that degree using the combo box I get the error. There appears to be ample room in the combo box to handle more than 6 chars. Any ideas? TIA, Gin I very strongly suspect that you have fallen victim to the Lookup Field misfeature. What is the Bound Column of this combo box? Is it a Lookup Field? If so, what is actually IN the table is a four-byte Number field; what you *see* on the screen is the value being looked up from the table. If that's not the case, please post your table structure and the datatypes of the relevant fields. John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|