Overflow mystery

[SiE]

Occassionally I get an overflow message when sending emails out from an access app. all i am doing is taking numbers from a form and assigning them to variables then building up a message as a string then sending them out as an E-Mail. The weird thing is that I will get an overflow error, go to debug then start running the code again and the thing works fine. the field i am assigning to is the correct datatype. I even tried changing the datatype to a variant and the problem still appears. weird!

 

[chrismcbride]

I don't know if this will help, but my experience with the Overflow error is that it is almost always caused by Null values in numeric equations or functions. You could use IsNull to substitute some value other than null to see if this solves your problem.
HTH
Chris

 

[SiE]

Cheers Chris,

Ive just had the problem again and noticed that one of the variable assigned previous to the error is not always capturing the data from the form resulting in a variable containing null. Its really strange because 99% of the time it works. If I step the code back to were the variable is assigned it captures the data properly and the proc works. Its as if a line of code is missed. Of course when you debug it hits the line everytime. guess im just gonna have to work a way round.