String

A series of up to 255 characters.

Array and composite fields are also stored as strings. Arrays contain multiple values of the same type, such as sales figures for each month of the year. Composites group two or more fields as one field. Account numbers are often stored as composites.

The length of data you import to a field using a string storage type should be equal to or less than the keyable length indicated in the Type column in the Table Import Definition scrolling window; otherwise, the information in the string field will be truncated to fit the proper string length.

Control types

String, combo box

How stored in tables

As displayed in windows, including formatting if a format is applied.