Function that converts an expression into a currency value.
Syntax
CCur (expression)
CCur cannot handle Null values, use Nz() to convert Nulls to a valid number.
Dim curSalary
curSalary = CCur(45.764321)
“Gold is the money of kings; silver is the money of gentlemen; barter is the money of peasants; but debt is the money of slaves” ~ Norm Franz
Q51414 - Internal Format of CURRENCY Data Type
CBool - Convert to boolean
CByte - Convert to byte
CDate - Convert to Date
CDbl - Convert to Double (number)
CDec - Convert to Decimal (number)
CInt - Convert to Integer (number)
CLng - Convert to Long (number)
Number Data Types
Convert to Base 36
Nz - Detect a NULL value or Zero Length string.