Act! data types

The following describes the Act! data types.

Field Type

Description

Annual Event

Date and time only, formatted according to the date and time settings in the Windows Regional Settings control panel.

Character

Alphanumeric characters (letters or numbers).

Currency

Numbers only, formatted according to the currency settings in the Windows Regional Settings control panel.

Date

Dates only, formatted according to the date settings in the Windows Regional Settings control panel. The field will contain a drop-down date selector.

Datetime

Date and time only, formatted according to the date and time settings in the Windows Regional Settings control panel. The field will contain a drop-down date/time selector.

Decimal

Numbers and decimal points only.

Email

Alphanumeric characters.

InitialCaps

Alphanumeric characters, formatted with a capital letter at the beginning of each word.

Key ID

A unique GUID.

Lowercase

Alphanumeric characters, formatted in all lowercase letters. (The Shift and Caps Lock keys have no effect in a lowercase field.)

Memo

Alphanumeric characters.

Monthly Event

Date and time only, formatted according to the date and time settings in the Windows Regional Settings control panel.

NChar

A Unicode compliant Char field.

Numbers

Numeric and decimal points only.

Phone

Numbers only.

Picture

A Varbinary image field. This field accepts image only.

RecordType

A Key ID.

Smalldatetime

A formatted Datetime field.

Smallint

An integer type representing data from -32,768 through 32,767.

Time

Times only, formatted according to the time settings in the Windows Regional Settings control panel. The field will contain a drop-down time selector.

Tinyint

An integer type representing data from 0 to 255.

Uppercase

Alphanumeric characters, formatted in all uppercase letters. (The Shift and Caps Lock keys have no effect in an uppercase field.)

URL Address

Alphanumeric characters. The address entered in the field becomes an active link to a URL.

Varbinary

Field accepts non-character data.

YesNo

Field accepts only a Yes or No selection.