Public Function MakeCurrency( _
ByVal vValue As Variant _
) As Variant MakeCurrency(0) = String$(8, 0)
MakeCurrency(1) = Chr$(16) + Chr$(39) + String$(6, 0)
MakeCurrency(2) = Chr$(32) + Chr$(78) + String$(6, 0)
MakeCurrency(2.5) = Chr$(168) + Chr$(97) + String$(6, 0)
IsNull(MakeCurrency(Null)) = TrueSee also: MakeCurrencyFast Function
CoerceToCurrency FunctionvValue: The Currency value whose bytes are to be interpreted as a string. vValue can be a numeric value, a date value, a numeric string, or a date string. Function returns Null if vValue is Null. Function returns an empty string if vValue cannot be fixed up to a number. Note: This function converts the string representation of the value to Unicode using the default code page of the system.
v1.3 Change: Removed 16-bit support from this function.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.