2007 Microsoft® Office System Step by Step, Second Edition

Restricting the Amount of Data in a Field

The Field Size property, which is valid for the Text, Number, and AutoNumber data types, restricts the number of characters that can be entered in a text field (from 0 to 255) and the number of digits that can be entered in a number or AutoNumber field. You can set number fields to any of the following values:

Setting	Description
Byte	Stores whole numbers from 0 to 255
Integer	Stores whole numbers from –32,768 to 32,767
Long Integer	(The default.) Stores whole numbers from –2,147,483,648 to 2,147,483,647
Single	Stores negative numbers from –3.402823E38 to –1.401298E–45 and positive numbers from 1.401298E–45 to 3.402823E38
Double	Stores negative numbers from –1.79769313486231E308 to –4.94065645841247E–324 and positive ...