>For some reason some num. fields in my table have numeric overflow,
>I don't know how to prevent the message 'Numeric overflow. Data was lost (Error 39)' when using this field

I suppose you could trap for that error (error 39).

See ON ERROR in the Help if you are not familiar with error handling.

Joe