CInt and CLng differ from the Fix and Int functions, which truncate, rather than round, the fractional part of a number. For example, 0.5 rounds to 0, and 1.5 rounds to 2. When the fractional part is exactly 0.5, CInt and CLng always round it to the nearest even number. For example, when you use CCur, different decimal separators, different thousand separators, and various currency options are properly recognized depending on the locale setting of your computer. You should use the data-type conversion functions instead of Val to provide internationally aware conversions from one data type to another. For example, use CCur to force currency arithmetic in cases where single-precision, double-precision, or integer arithmetic normally would occur.
#ACCESS VBA CONVERT STRING TO LOWERCASE CODE#
In general, you can document your code using the data-type conversion functions to show that the result of some operation should be expressed as a particular data type rather than the default data type. Implicit conversions of LongLong to smaller integrals are not allowed. If the expression passed to the function is outside the range of the data type being converted to, an error occurs.Ĭonversion functions must be used to explicitly assign LongLong (including LongPtr on 64-bit platforms) to smaller integral types.
Returns for CStr depend on the expression argument. The function name determines the return type as shown in the following: Function The required expression argument is any string expression or numeric expression. CLngLng( expression ) (Valid on 64-bit platforms only.).Each function coerces an expression to a specific data type.
0 kommentar(er)
