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. |
|
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. |