Err 3759 Scaling of decimal value resulted in data truncation 
Author Message
 Err 3759 Scaling of decimal value resulted in data truncation

Dear newsgroup,

I've just converted my access db from 97 to 2002. I now
obtain the following error msg from my vb code:

Error 3759: Scaling of decimal value resulted in data
truncation.

It is prompted by the last line of the following function
I am using to obtain a rounded number:

Public Function fctRound(Optional varNr, Optional varPl As
Integer = 2) As Double
 ' Source: www.donkarl.com
    If IsMissing(varNr) Or Not IsNumeric(varNr) Then Exit
Function
    fctRound = Fix("" & varNr * (10 ^ varPl) + Sgn(varNr)
* 0.5) / (10 ^ varPl)
End Function

Can anybody explain to me why this error msg appears
(unfortunately I cannot access the corresponding section
of the online help)?

Many thanks,
Lorenz



Fri, 11 Nov 2005 00:34:49 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Random truncation of results

2. Data type problem - invalid scale value

3. A2k: truncation of field values

4. Passing text Values with 's included (Truncation)

5. Passing text Values with 's included (Truncation)

6. Please help - howto set the precision and numeric scale for a decimal type parameter

7. FYI: Different result with Multipage1.Value = Multipage1.Value + 1 or - 1

8. FlexGrid & Data Truncation indication

9. Data Truncation Error

10. 01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right truncation

11. -2147217889 [ODBC SQL Server Driver] String Data, Right Truncation

12. Pushing time scaled values into project

 

 
Powered by phpBB® Forum Software