请教! 如何将 String 转换成 Integer 或 Double

Stinger

用哪个函数?
谢谢指教!

HG

cint()

Stinger

谢谢!
不过ACCESS的 Integer 太小了,只相当于 SQL 的 Tinyint.

导致我的程序 Overflow.

HG

還有cdbl(),ccur(),cdec()分別來轉換雙精度的，貨幣的，和decimal()類型 的.

Stinger

我把它补全吧!

CBool(expression)

CByte(expression)

CCur(expression)

CDate(expression)

CDbl(expression)

CDec(expression)

CInt(expression)

CLng(expression)

CSng(expression)

CStr(expression)

CVar(expression)

Function | Return |  Remark
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.
CDate      Date      Any valid date expression.
CDbl       Double    -1.79769313486231E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values.

CDec        Decimal   +/-79,228,162,514,264,337,593,543,950,335 for zero-scaled numbers, that is, numbers with no decimal places. For numbers with 28 decimal places, the range is
+/-7.9228162514264337593543950335. The smallest possible non-zero number is 0.0000000000000000000000000001.

CInt        Integer    -32,768 to 32,767; fractions are rounded.
CLng        Long       -2,147,483,648 to 2,147,483,647; fractions are rounded.
CSng        Single     -3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38 for positive values.

CStr        String     Returns for CStr depend on the expression argument.
CVar        Variant Same range as Double for numerics. Same range as String for non-numerics.