Character – General

Displays values as a string of up to 254 characters.

Date/Time – General

Displays date as "yyyymmdd"  if there is a non-zero  datepart. Displays time as "hh:mm:ss" if there is a non-zero time part.  If both the date and time parts are zero, this format shows "00:00:00"  (i.e.,midnight).

Date/Time – Short Date

Shows the date using the currently-configured Windows Short Date setting (e.g., April 16, 2003 might be represented as “04/16/2003”). Does not show the time.

Date/Time – Long Date

Displays dates as specified by the Windows Long Date setting (April 16, 2003 might be represented as “Wednesday, April 16, 2003”). Does not show the time.

Date/Time – Short Date & Time

Shows the date using the currently-configured Windows Short Date setting and displays time (if present) using the currently-configured Windows Time setting (April 16, 2003 at 11:03 in the morning might be represented as 04/16/2003 11:03 AM).

If both the date and time parts are zero, this format shows midnight, as represented by the current Windows Date and Time display configuration.

Date/Time – Long Date & Time

Shows the date using the currently-configured Windows Long Date setting and displays time (if present) using the currently-configured Windows Time setting (April 16, 2003 at 11:03 in the morning might be represented as Wednesday, April 16, 2003 11:03 AM).

If both the date and time parts are zero, this format shows midnight, as represented by the current Windows Date and Time display configuration.

Date/Time – Time

Displays time as "hh:mm:ss" if there is a non-zero time part. Does not display the date.

Numeric – General

Displays numbers in their most compact form (e.g., 123.45).

Numeric – Thousands

Displays numbers with a thousands separator, e.g., 1,234.56. The separator and format uses the currently-configured Windows Number formats.

Numeric – Currency

Displays numbers as specified by the currently-configured Windows Currency settings (these settings specify how numbers should be represented in the local currency, e.g., $1,235)

Numeric – Percentage

Displays numbers as a percentage of 1 (i.e., 1 is represented as 100%).

Numeric - Time Span

Displays elapsed time in seconds in HHHH:MM:SS.sss format in both tables and summaries. For example, in a Time Span field an elapsed time of 70 seconds (i.e., 1 minute and 10 seconds) would be displayed as "00:01:10".

Memo - General

Displays values as a string. Memo field length is determined by the data in the field, with a maximum length of 64KB.