O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

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

Using Field Size Properties to Restrict Data

Using Field Size Properties to Restrict Data

You can set the Field Size property for the Text, Number, and AutoNumber data types. This property restricts the number of characters that you can enter in a text field and the size of numbers that can be entered in a number or AutoNumber field. For text fields, the Field Size property can be set to any number from 0 to 255. AutoNumber fields are automatically set to Long Integer. Number fields can be set to any of the following values:

Setting

Description

Byte

Stores numbers from 0 to 255 (no fractions).

Integer

Stores numbers from –32,768 to 32,767 (no fractions).

Long Integer

(The default.) Stores numbers ...

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