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: CCur Function

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


The Microsoft Access CCur function converts a value to currency.


The syntax for the Microsoft Access CCur function is:

CCur( expression )

Parameters or Arguments

expression is the value to convert to currency.

Applies To

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

Example (in VBA Code)

The CCur function can be used in VBA code in Microsoft Access. For example:

Dim LValue As Double
Dim LCurValue As Currency

LValue = 123.4567812
LCurValue = CCur(LValue)

In this example, the CCur function would return the value 123.4568. The variable called LCurValue would now contain 123.4568.