Error 3163 in subform (on combobox)

[IanMilly]

I have a combo box on a subform. The combobox gets the values from a lookup table. I have two fields in this table , Description and part number. when i try and use the combox, i can see the values of the table, however afterupdat i get an error message:

"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data (Error 3163)


The field size is set to 250 - the part numbers don't go anywhere never this length (i tried this size to attempt to get rid of the error).

Field 2 is the bound column of the combo box
The combo box was added to the form (and to the table) after the form was originally made. I don't think this would have an effect - but am unsure.



Any Ideas as it is quite frustrating!

Thanks for any help in advance

Ian