Comment Box Funny Error Msg & Text Box Problems

[emcc]

I have two problems on my form....

I have a comment box that when I either try to enter text into it or leave it blank that gives this error message:

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

I checked the properties of both the comment box on the form and comments in the table and there are no special settings that I can see to cause this problem.

My text box problem is that when working in the actual form it will not allow me to enter data into it. I don't get an error message or anything just the little bell. Again I have no special settings in the properties. I'm not sure if the fact that this is the primary key in its table has anything to do with this?

 

[AlanS]

For the comment box, you may have a default value (possible all blanks) set that is longer than the maximum length of the underlying table field, or you may have VBA code that is attempting to insert data in the field, perhaps in response to some event.

For the text box, double check the Locked property in the form.

Hope this helps.