VBScript in a Nutshell

Name

CCur Function

Syntax

CCur(expression)

expression

Use: Required

Data Subtype: Numeric or String

A string or numeric expression that evaluates to a number between -922,337,203,685,477.5808 and 922,337,203,685,477.5807.

Return Value

expression converted to a Variant with a subtype of Currency.

Description

Converts an expression into a Variant with a subtype of Currency.

Rules at a Glance

• If the expression passed to the function is outside the range of the Currency data subtype, an overflow error occurs.

• Expressions containing more than four decimal places are rounded to four decimal places.

• The only localized information included in the value returned by CCur is the decimal symbol.

Example

If IsNumeric(sMyNumber) Then
    curMyNumber = CCur(sMyNumber)
End If

Programming Tips & Gotchas

• CCur doesn’t prepend or append a currency symbol; for this, you need to use the FormatCurrency function. CCur does, however, correctly convert strings that include a localized currency symbol. For instance, if a user enters the string “$1234.68” into a text box whose value is passed as a parameter to the CCur function, CCur correctly returns a currency value of 1234.68.

• CCur doesn’t include the thousands separator; for this, you need to use the FormatCurrency function. CCur does, however, correctly convert currency strings that include localized thousands separators. For instance, if a user enters the string “1,234.68” into a text box whose value is passed as a parameter to the CCur function, CCur correctly converts ...