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 ... |
Get Microsoft® Office Access 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
