Table, table fields, and table extension properties

This article lists properties that apply to the table object and table fields and, in some cases, to the table extension object as specified below.

Note

This article may not include all properties for this object. To see a complete list of properties, use the table of contents from Properties Overview. In Visual Studio Code, use Ctrl+Space to see the properties available for the object and its controls.

Property Name Available for Table
Extension Object
Applies to
Access Property
  • Table
  • Table fields
AccessByPermission Property
  • BLOB field
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • TableFilter field
  • Text field
  • Time field
AutoFormatExpression Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
AutoFormatType Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
AutoIncrement Property
  • BigInteger field
BlankNumbers Property
  • BigInteger field
  • Boolean field
  • Date field
  • DateTime field
  • Decimal field
  • Duration field
  • Integer field
  • Option field
  • Time field
BlankZero Property X
  • BigInteger field
  • Boolean field
  • Decimal field
  • Duration field
  • Integer field
  • Option
CalcFormula Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • Media field
  • MediaSet field
  • Option field
  • RecordID field
  • Text field
  • Time field
Caption Property X
  • Table object
  • BLOB Field
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • TableFilter field
  • Text field
  • Time field
CaptionClass Property X
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
CaptionML Property X
  • Table object
  • BLOB Field
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • TableFilter field
  • Text field
  • Time field
CharAllowed Property
  • Code field
  • OemCode field
  • OemText field
  • Text field
ClosingDates Property X
  • Date field
Compressed Property
  • BLOB field
Data Type
  • Table fields
DataCaptionFields Property X
  • Table object
DataPerCompany Property
  • Table object
DateFormula Property
  • Code
  • OemCode field
  • OemText field
  • Text field
Description Property X
  • Table object
  • BLOB field
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • TableFilter field
  • Text field
  • Time field
DrillDownPageID Property X
  • Table object
Editable Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
Enabled Property
  • BLOB field
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • TableFilter field
  • Text field
  • Time field
ExtendedDataType Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
Extensible Property
  • Table object
ExternalName Property
  • Table object
ExternalSchema Property
  • Table object
FieldClass Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
InitValue Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
LinkedInTransaction Property
  • Table object
LinkedObject Property
  • Table object
LookupPageID Property X
  • Table object
MaxValue Property
  • BigInteger field
  • Boolean field
  • Date field
  • DateTime field
  • Decimal field
  • Duration field
  • Integer field
  • Option field
  • Time field
MinValue Property
  • BigInteger field
  • Boolean field
  • Date field
  • DateTime field
  • Decimal field
  • Duration field
  • Integer field
  • Option field
  • Time field
NotBlank Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
Numeric Property
  • Code field
  • OemCode field
  • OemText field
  • Text field
ObsoleteReason
  • Table object
  • Table keys
  • Table fields
ObsoleteState
  • Table object
  • Table keys
  • Table fields
ObsoleteTag
  • Table object
  • Table keys
  • Table fields
OptionCaption Property X
  • Option field
OptionMembers Property
  • Option field
PasteIsValid Property
  • Table object
Permissions Property
  • Table object
ReplicateData Property
  • Table object
Scope (Table) Property
  • Table object
SignDisplacement Property
  • BigInteger field
  • Boolean field
  • Date field
  • DateTime field
  • Decimal field
  • Duration field
  • Integer field
  • Option field
  • Time field
SQLDataType Property
  • Code field
  • OemCode field
SqlTimeStamp Property
  • BigInteger
SubType Property (BLOB)
  • BLOB field
TableRelation Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
TableType Property
  • Table object
ValidateTableRelation Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
ValuesAllowed Property
  • BigInteger field
  • Boolean field
  • Code field
  • Date field
  • DateFormula field
  • DateTime field
  • Decimal field
  • Duration field
  • GUID field
  • Integer field
  • OemCode field
  • OemText field
  • Option field
  • RecordID field
  • Text field
  • Time field
Width Property X
  • BigInteger field
  • Code field
  • Decimal field
  • Duration field
  • Integer field
  • OemCode field
  • OemText field
  • Text field

See also

Properties
Page and page extension properties