Access Module Importing Word Form

[alexkeel79]

I wrote an access module which imports a word form. It has worked fine the past few weeks but now I am getting the following error with one file:

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

I checked all the fields and they all seem to be under the size limits that I set in the table. Any idea on what this error is or how I can tell which field the error is referring to? Thanks in advance.

 

[Frink]

Hallo,

Trap the error and do a Resume to go to the offending line. If it's in an SQL statement, print it in the immediate window, then paste that into a query and run it. That'll tell you where the problem is.

- Frink