Overflow Error

[mordja]

Hi,

Im getting an overflow error, which gives me very little information "Overflow Error" about the cause. What is the best way to track down the cause of an overflow ?

Thanks

Mordja

 

[lupins46]

The general problem is that the result of a calculation cannot be held in the variable/field that is assigned or implied. For example multiplying two numbers defined as Integers can easily produce a result which requires a Long integer to hold it.

But you can get overflow errors in less obvious situations, where Access is manipulating stuff internally.
Where are you getting this message?

 

[mordja]

Lupins,

Thanks, Tracked it down. I understand why overflows occur, but not why access gives so little information as to where it was caused.

Mordja