FormatCurrencyV Method, SftMaskCalculator Object
Converts a value into a displayable currency string.
Syntax
| VB.NET | object.FormatCurrencyV(ByVal Val As Double, ByVal FracDigits As Short, ByVal LeadZero As Short, ByVal Grouping As Short, ByVal DecimalSep As String, ByVal ThousandSep As String, ByVal NegativeOrder As Short, ByVal PositiveOrder As Short, ByVal CurrencySymbol As String, ByRef Text As Object) |
| VB | object.FormatCurrencyV(ByVal Val As Double, ByVal FracDigits As Integer, ByVal LeadZero As Integer, ByVal Grouping As Integer, ByVal DecimalSep As String, ByVal ThousandSep As String, ByVal NegativeOrder As Integer, ByVal PositiveOrder As Integer, ByVal CurrencySymbol As String, Text As Variant) |
| C#.NET | void object.FormatCurrencyV(double Val, short FracDigits, short LeadZero, short Grouping, string DecimalSep, string ThousandSep, short NegativeOrder, short PositiveOrder, string CurrencySymbol, out object Text); |
| VC++ | HRESULT object->FormatCurrencyV(double Val, short FracDigits, short LeadZero, short Grouping, _bstr_t DecimalSep, _bstr_t ThousandSep, short NegativeOrder, short PositiveOrder, _bstr_t CurrencySymbol, const _variant_t&* Text); |
| C | HRESULT object->raw_FormatCurrencyV(double Val, short FracDigits, short LeadZero, short Grouping, BSTR DecimalSep, BSTR ThousandSep, short NegativeOrder, short PositiveOrder, BSTR CurrencySymbol, VARIANT* Text); |
object
A SftMaskCalculator object.
Val
A Double. This value is formatted as a string using the provided attributes and returned in Text.
FracDigits
The number of desired fractional digits (0-99) or -1. If -1 is specified, the user locale is used (see GetLocaleInfo, LOCALE_ICURRDIGITS).
LeadZero
1 if leading zeros are desired, otherwise 0. If -1 is specified, the user locale is used (see GetLocaleInfo, LOCALE_ILZERO).
Grouping
Specifies the size of each group of digits to the left of the decimal point (0-9). If -1 is specified, the user locale is used (see GetLocaleInfo, LOCALE_SMONGROUPING).
DecimalSep
The decimal separator string (up to four characters). If an empty string is specified, the user locale is used (see GetLocaleInfo, LOCALE_SMONDECIMALSEP).
ThousandSep
The thousands (group) separator string (up to five characters). If an empty string is specified, the user locale is used (see GetLocaleInfo, LOCALE_SMONTHOUSANDSEP).
NegativeOrder
The display mode for negative values (0-15). If -1 is specified, the user locale is used (see GetLocaleInfo, LOCALE_INEGCURR).
| NegativeOrder | Example | Description |
|---|
| -1 | | The user locale is used (see GetLocaleInfo, LOCALE_INEGCURR) |
| 0 | ($1.1) | Left parenthesis, monetary symbol, number, right parenthesis |
| 1 | -$1.1 | Negative sign, monetary symbol, number |
| 2 | $-1.1 | Monetary symbol, negative sign, number |
| 3 | $1.1- | Monetary symbol, number, negative sign |
| 4 | (1.1$) | Left parenthesis, number, monetary symbol, right parenthesis |
| 5 | -1.1$ | Negative sign, number, monetary symbol |
| 6 | 1.1-$ | Number, negative sign, monetary symbol |
| 7 | 1.1$- | Number, monetary symbol, negative sign |
| 8 | -1.1 $ | Negative sign, number, space, monetary symbol (like 5, but with a space before the monetary symbol) |
| 9 | -$ 1.1 | Negative sign, monetary symbol, space, number (like 1, but with a space after the monetary symbol) |
| 10 | 1.1 $- | Number, space, monetary symbol, negative sign (like 7, but with a space before the monetary symbol) |
| 11 | $ 1.1- | Monetary symbol, space, number, negative sign (like 3, but with a space after the monetary symbol) |
| 12 | $ -1.1 | Monetary symbol, space, negative sign, number (like 2, but with a space after the monetary symbol) |
| 13 | 1.1- $ | Number, negative sign, space, monetary symbol (like 6, but with a space before the monetary symbol) |
| 14 | ($ 1.1) | Left parenthesis, monetary symbol, space, number, right parenthesis (like 0, but with a space after the monetary symbol) |
| 15 | (1.1 $) | Left parenthesis, number, space, monetary symbol, right parenthesis (like 4, but with a space before the monetary symbol) |
PositiveOrder
The display mode for positive values (0-3). If -1 is specified, the user locale is used (see GetLocaleInfo, LOCALE_ICURRENCY).
| PositiveOrder | Example | Description |
|---|
| -1 | | The user locale is used (see GetLocaleInfo, LOCALE_ICURRENCY) |
| 0 | $1.1 | Prefix, no separation |
| 1 | 1.1$ | Suffix, no separation |
| 2 | $ 1.1 | Prefix, 1-character separation |
| 3 | 1.1 $ | Suffix, 1-character separation |
CurrencySymbol
The currency symbol string (up to six characters). If an empty string is specified, the user locale is used (see GetLocaleInfo, LOCALE_SMONDECIMALSEP). If the string "none" is specified, no currency string is used.
Text
The formatted string is returned in the Text argument.
Comments
The FormatCurrencyV method converts a value into a displayable currency string.
Calculator.FormatNumberV is used to format numbers without currency attributes.
FormatCurrencyV is used for languages such as VBScript, which are limited by requiring Variant arguments and do not support strongly typed arguments for return values. For more information please see Using SftMask/OCX with Internet Explorer.
See Also SftMaskCalculator Object | Object Hierarchy
On
Off