tech on the net

MS Access: CCur Function

In Microsoft Access, the CCur function converts a value to currency.

Syntax

The syntax for the CCur function is:

CCur( expression )

expression is the value to convert to currency.

Applies To

VBA Code

The CCur function can be used in VBA code. 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.46. The variable called LCurValue would now contain $123.46.