"field too small to accept amount of data you attempted to add" er

[Guest]

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

 

[Guest]

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

 

[John W. Vinson]

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]