CCur

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.

Example

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

Related:

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.


© Copyright SS64.com 1999-2013
Some rights reserved