Setting the Field Size

For Text fields, the field size is the maximum number of characters that a user can type in the field. For Number fields, however, the size is determined by the selected data size:

Size

Description

Byte

Stores numbers from 0 to 255 (no fractions).
Decimal precision: None
Storage size: 1 bytes

Integer

Stores numbers from –32,768 to 32,767 (no fractions).
Decimal precision: None
Storage size: 2 bytes

Long Integer

Stores numbers from -2,147,483,648 to 2,147,483,647 (no fractions).
Decimal precision: None
Storage size: 4 bytes

Single

Stores numbers from
–3.402823E38 to
–1.401298E–45 for negative values and from
1.401298E–45 to 3.402823E38 for positive values.
Decimal precision: 7
Storage size: 4 bytes

Double

Stores numbers from
–1.79769313486231E308 to
–4.94065645841247E–324 for negative values and from 1.79769313486231E308 to 4.94065645841247E–324 for positive values.
Decimal precision: 15
Storage size: 8 bytes

Related Topics

Choosing a Field Type