tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Access: CInt Function

Learn how to use the Access CInt function with syntax and examples.


The Microsoft Access CINT function converts a value to an integer.


The syntax for the Microsoft Access CInt function is:

CInt( expression )

Parameters or Arguments

expression is the value to convert to an integer.

Applies To

The CInt function can be used in the following versions of Microsoft Access:

Example (in VBA Code)

Dim LValue As Integer

LValue = CInt(8.45)

In this example, the variable called LValue would now contain the value of 8.

Be careful using CInt. If you were to use the following code:

Dim LValue As Integer

LValue = CInt(8.5)

The variable LValue would still contain the value of 8. Until the fraction is greater than .5, the CInt 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 CInt function to simulate the regular rounding process.

For example, CInt(8.50001) will result in a value of 9.