O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required