Hi,
When i type numbers that are larger then 2147483647(The long limit) ther always appears a # sign, why is that and how can i get this away. I would like to do this simple code:
msgbox cdec(2147483648)
but when i type this i get the following in my code if i change line:
MsgBox CDec(2147483648#)
Thanx
I don't know why this happens, as you said it is the long upper limit. Longs have 4 bytes allocated to them, whereas Doubles have 8 and Decimals have 14. Making the decimal maximum about 8*10^23 or 79,228,162,514,264,337,593,543,950,335. To actually find out how to get round this, or to see if your doing anything wrong, i'd need to see the code your writing.
Hot me back with the code and ill see what i can do.
The code is not realy special. it's a small program that checks a banking number. So if a user enters the number 833-4514319-03 the program has to say if the code is correct (if you divide the first 10 figures by 97 the rest must be 03)
So this is my code:
if CDec(Left(Text1, 3) & Mid(Text1, 5, 7)) mod 97 = cint(right(text1,2)) then
msgbox "OK"
else msgbox "Not OK"
end if
And even this simple thing does not work:
msgbox CDec(Left(Text1, 3) & Mid(Text1, 5, 7)) mod 97
What well works is:
CDec(Left(Text1, 3) & Mid(Text1, 5, 7)) / 97
And if you type in your code window the number 8334514319, vb adds automaticly the # sign when you goto another line.
I find it verry strange.
Thanx 4 your reply
Right. After a little testing, i see you problem. What its the fundamental difference with the first two sections of code, and the last one.
Answer? The Mod operator. You get an overflow error with the mod operator because it is not desgined for that kind of number. Offhand, I cant think of how you could do it otherwise.
My best suggestion would be to do a Floating Point division of the bank account number by 97 into a double variable. Then check to see if the 1st 2 digits after the decimal point are equal to '03' for example. If you have any problems, hit me back.
Oh yeah, just incase you want to know.
# is the type declaration character for a Double Value.
Just like $ is for a string and & for a long.
Ok, i found a different way to do this, did not know that the mod function did'nt allow figures larger than long.
Thanx for youre help
well if i'm not mistaken all you want to do is take a number and put it in a msgbox right? so, just typecast it:
msgbox Str(number)
hope this helps
- nc