Although the ACCESS numeric data type can also input strings, it is limited to strings that can be successfully converted into numbers, and those strings that cannot be converted into numbers cannot be saved in the numeric data type field. Even if a string can be converted into a number, its numerical size is not allowed to exceed a specific range of sub-number types. Characters that can be converted into numbers are limited to 0-9,+,-and decimal point (the plus sign will be removed after conversion, and the decimal part of integer type will also be removed).

Digital data type is a general term. Different number types have their own number ranges. The following is the maximum number of characters that can be entered for different number types without exceeding the limit:

Byte):3 Type: 3.

Integer: 5.

Dragon: 10.

Single): 38 Sperm: 38

Double):308。