Define the Type of Value that is Stored in a Standard Custom Field
When you add an extra field, you need to specify the type of value that can be stored in the field so that it is appropriate for your requirements. To do this, you need to use the Type setting on the Edit Field window.
To access the Edit Field window, see Add a New Extra Field. You can also use the Edit Field window to modify the type of an existing custom field (see Modify an Existing Extra Field).
When you have displayed the Edit Field window, use the Type setting to choose the data type for the field:
- Type—Choose from:
- Word—A 16-bit integer in the range -32,768 to 32,767
- Unsigned Word—A 16-bit integer in the range 0 to 65,535
- Long—A 32-bit integer in the range -2,147,483,648 to 2,147,483,647
- Unsigned Long—A 32-bit integer in the range 0 to 4,294,967,295
- Long Long—A 64-bit integer in the range –9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
- Unsigned Long Long—A 64-bit integer in the range 0 to 18,446,744,073,709,551,615
- Byte—An 8-bit integer in the range -128 to 127
- Float—A single precision floating value (real value)
- Double—A double precision floating value (real value)
- Reference—A database reference
- String—An alphanumeric value of a defined length
- Boolean—A True/False value
- Variant—Any data type (used by VB programs)
- Time—A time stamp value.
When you have defined the Type setting, you can continue to define the other field settings as required.