Numeric Field Overflow

[Guest]

Hi. I have a Form where I have a combo box in the header. The user will
enter data in this box and the data will display in the form body.

My problem is that for some of the records, I receive the following error:
"Run Time error 3349 - numeric field overflow"

I am not sure what the problem is ... can anyone give insight?

Thanks,
Mike.

 

[Douglas J. Steele]

What type of field are you putting the data into? If, for example, you're
trying to put a value in an Integer field, and the value is greater than
32,767 (or less than -32,768), you'll get that error.

 

[Guest]

Hi, Doug.

The field is simplay a text field. One of the records that will not appear
has the text "TR101" in the field.

 

[Douglas J. Steele]

Is the textbox bound to a field in the underlying query (or table)? If so,
what's the datatype of that field?