Just like tables, all the fields in C/SIDE have a number of properties that determine their behavior. When you create a field, C/SIDE automatically suggests a number of default values for these properties. Depending on the purpose of the field, you will sometimes want to change these default values.

C/SIDE contains the following field properties. The first table list the properties that are common to most field types.

Property name Description

Field No. Property

Assigns a unique numeric ID to this field.

Name Property

Specifies the name of the field.

Caption Property

Specifies the text used to identify a control based on the field.

CaptionML Property

Specifies the text that is used to identify a control or other object in the user interface. The CaptionML property is multilanguage enabled and can contain a list of text in different languages. The text that is used is selected according to the current language setting of the user.

CaptionClass Property

Controls the caption that is used in the label of a field in a database table or in the label of a control on a form.

Description Property

Includes an optional description of the field. This description is for internal purposes only and is not visible to the end user.

Data Type Property

Specifies the data type of a table field.

Enabled Property

Determines whether the field is enabled.

A field may have additional properties, depending on its data type. The following table lists properties that apply to various field types.

Property Name Description

DataLength Property

Specifies the maximum length of the data stored in a code or text field.

InitValue Property

Defines an initial value for a field.

FieldClass Property

Define the class for a field. That is, specifies whether it is a normal field, a FlowField, or a FlowFilter field.

CalcFormula Property

Defines a formula used by a FlowField.

AltSearchField Property

Defines an alternative search field.

DecimalPlaces Property

Sets the number of decimal places shown to the user. This property also performs validation of whether user input conforms to this setting.

Editable Property

Determines whether a field can be edited.

NotBlank Property

Forces the user to make a non-blank entry in this field.

BlankNumbers Property

Determines whether a range of numbers will be set to blank as they are formatted.

Numeric Property

Forces the user to enter numbers in this field.

CharAllowed Property

Sets the characters you will allow the user to enter in this field.

DateFormula Property

Validates the syntax of a date expression entered by the user.

Standard day/time unit Property

Specifies the unit of measure that is used when you enter data into Duration fields.

MinValue Property

Sets the minimum value for the contents of a field.

MaxValue Property

Sets the maximum value for the contents of a field.

Title Property

Adds a title to a field. The first letter in each word is capitalized.

ValuesAllowed Property

Specifies the values you want to allow in the field. Can be specified either as a range or as distinct values, or as a combination of these.

AutoIncrement Property

Specifies whether each field value is automatically given a new number that is greater than the number given to the previous value.

TableRelation Property

Defines relationships to other tables. For more information, see Setting Relationships Between Tables.

ValidateTableRelation Property

Indicates whether a table relationship is validated.

TestTableRelation Property

Indicates whether the field is included in table relationship tests.

TableIDExpr Property

Specifies the ID of the table to which you want to apply a table filter.

BlankZero Property

Determines whether the fields appears blank if the value is 0 (zero) or FALSE.

DataLength Property

Defines the length of a data field.

OptionString Property

Defines an option string (a comma-separated string of options). The maximum size is 1000 characters.

ClosingDates Property

Determines whether closing dates are allowed.

AutoFormatType Property

Determines how data is formatted.

AutoFormatExpr Property

Determines how data is formatted.

SignDisplacement Property

Shifts negative values to the right for display purposes.

SQL Data Type Property

Specifies the data type you want to allow in a code field. This property applies to code fields in the SQL Server Option for Microsoft Dynamics NAV.

ClearOnLookup Property

Specifies whether the current contents of the field are deleted before the value the user selects via the lookup is added.

SubType Property

Defines the subtype of a BLOB field, for example a Bitmap or a Memo.

Compressed Property

Specifies whether a BLOB is compressed. This property only applies to BLOB fields and only on the SQL Server Option.

OptionCaption Property

Defines the text string options that are displayed to the user.

OptionCaptionML Property

Sets the strings that are displayed to the user for selecting an option. The OptionCaptionML property is only used if the field has an OptionString property. The OptionString property contains the set of values that are acceptable choices, and it is one of these values that will be saved in the database or used in C/AL code.

Expand imageSee Also