Access: CCur Function

Question:  How do I convert a value to currency?

Answer:  To convert a value to currency, use the "CCur" function. The syntax for the CCur function is:

CCur( expression )

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.