Field type

Data allowed in fields

Address

Alphanumeric characters (letters, numbers, or symbols).

Annual Event

Dates that annually recur, formatted according to the date settings in the Microsoft Windows Regional Settings control panel. The field contains a drop-down date selector.

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 contains a drop-down date selector.

Date/Time

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

Decimal

Numbers and decimal points only.

E-mail

Alphanumeric characters. The address entered in the field becomes an active link to open e-mail.

Initial-Caps

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

Lowercase

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

Memo

Alphanumeric characters (letters, numbers, or symbols).

Number

Numbers only. If you type a letter in this field, it is ignored.

Phone

Numbers only.

Picture

Pictures in .bmp, .gif, .jpg, .png, .ico, .emf, or .wma format.

Time

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

Uppercase

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

URL Address

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

Yes/No

Check box. If the check box is selected, it has a "Yes" value. If the check box is cleared, it has a "No" value.