• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Keeping Your Information Accu... > Using Field Size Properties to Restr...

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:


SettingDescription
ByteStores numbers from 0 to 255 (no fractions).
IntegerStores numbers from –32,768 to 32,767 (no fractions).
Long Integer(The default.) Stores numbers from –2,147,483,648 to 2,147,483,647 (no fractions).
SingleStores numbers from –3.402823E38 to –1.401298E–45 for negative values and from 1.401298E–45 to 3.402823E38 for positive values.
DoubleStores numbers from –1.79769313486231E308 to –4.94065645841247E–324 for negative values and from 1.79769313486231E308 to 4.94065645841247E–324 for positive values.
DecimalStores numbers from -10^28 -1 through 10^28 -1.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint