MS Access: CLng Function
This MSAccess tutorial explains how to use the Access CLng function with syntax and examples.
Description
The Microsoft Access CLng function converts a value to a long integer.
Syntax
The syntax for the CLNG function in MS Access is:
CLng( expression )
Parameters or Arguments
- expression
- The value to convert to a long integer.
Returns
The CLng function returns a long integer value.
Applies To
The CLng function can be used in the following versions of Microsoft Access:
- Access 2019, Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000
Example in VBA Code
The CLng function can be used in VBA code in Microsoft Access.
For example:
Dim LValue As Long LValue = CLng(35150.45)
In this example, the variable called LValue would now contain the value of 35150.
Be careful using CLng. If you were to use the following code:
Dim LValue As Long LValue = CLng(35150.5)
The variable LValue would still contain the value of 35150. Until the fraction is greater than .5, the CLng function will not round the number up.
If the fraction is less than or equal to .5, the result will round down.
If the fraction is greater than .5, the result will round up.
We've found it useful in the past to add 0.0001 to the value before applying the CLng function to simulate the regular rounding process.
For example, CInt(35150.50001) will result in a value of 35151.
Advertisements