ACC: Data Type of Value Overrides Data Type of VariableLast reviewed: August 29, 1997Article ID: Q98796 |
The information in this article applies to:
SUMMARYModerate: Requires basic macro, coding, and interoperability skills. Microsoft Access internally converts values with implicit data type definitions before assigning those values to variables. This may result in unexpected rounding of numbers, or in the following error message:
Invalid Number MORE INFORMATIONYou can implicitly define the data type of a value by appending a type-declaration character at the end of the value. For example, x=1234& implicitly defines 1234 as a Long data type (four-byte integer). To see how this works, follow these steps:
|
Additional query words: ui misc
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |