Data Truncation (without Rounding) in VBA Access October 18, 2019October 18, 2019 Nazim Uddin Use the below function to truncate data in VBA Access Function Trunc(number1 As Double, DecPlace As Integer) As Double Trunc = Fix(number1 * 10 ^ DecPlace) / 10 ^ DecPlace End Function