Data transformations that may be used when using an Access database

Type conversion number of Han:

function return type expression parameter range

CBool Boolean Any valid string or numeric expression.

CByte Byte 0 to 255.

CCur currency-922,337,203,685,477.5808 to 922,337,203,685,477.5807.

Any valid date expression for CDate date.

CDBL Double negative from -1.79769313486232E308 to -4.94065645841247E-324; positive numbers from 4.94065645841247E-324 to 1.79769313486232E308.

CDEC Decimal 0 Variable ratio, that is, no decimal digits, for

+/-79,228,162,514,264,337,593,543,950,335. For a value of 28 decimal digits, the range is

+/-7.9228162514264337593543950335: The smallest possible 0 value is 0.0000000000000000000000000001.

CInt integer-32,768 to 32,767, fractional part rounded.

CLng long-2,147,483,648 to 2,147,483,647, fractional part rounded.

The CSng single negative number is -3.402823E38 to -1.401298E-45, and a positive number is 1.401298E-45 to 3.402823E38.

The CStr String returns CSTR based on the expression parameter.

If the CVar Variant is a numeric value, the range is the same as a Double, and if not a numeric value, the range is the same as a String.