911!! when one filed is edited it changes another field.

[SA812]

I have a DCO databse that uses a form in datasheet view to enter items. Now when one field is changed some how it changes the text in another field to little boxes and i get an error message "record is to large". This happens on 4 fields you change two of the fields the other two change to symbols. They are all text fields 255char. they are all named differently.

"Man i need some new chicken bones!!!"
SA

 

[KerryL]

Not sure if I have enough to go on.

Are the fields that change (when text is entered in the first ones) linked somehow? Did you add code that makes those fields change based on what is entered in the first?

The second fields are somehow dependent on the entries in the first. Is this the way you intended it to be?

If yes, is it just a formatting/font issue? If no, you'll need to get rid of the code that updates the second fields or simply delete those fields and create new ones.