Tables

Properties of Fields

• Field Size is used to set the number of characters needed in a text or number field. The default field size for the text type is 50 characters. If the records in the field will only have two or three characters, you can change the size of the field to save disk space or prevent entry errors by limiting the number of characters allowed. Likewise, if the field will require more than 50 characters, enter a number up to 255. The field size is set in exact characters for Text type, but options are give for numbers:

o Byte - Positive integers between 1 and 255

o Integer - Positive and negative integers between -32,768 and 32,768

o Long Integer (default) - Larger positive and negative integers between -2 billion and 2 billion.

o Single - Single-precision floating-point number

o Double - Double-precision floating-point number

o Decimal - Allows for Precision and Scale property control