Reference > Functions reference > Design functions > FieldComment
 

FieldComment

Returns the specified field's comment.

Format 

FieldComment ( fileName ; fieldName )

Parameters 

fileName - the name of an open database file (local or remote).

fieldName - the name of a field in the specified database file.

Data type returned 

text

Originated in version 

7.0

Description 

The field name must be in the form tablename::fieldname to specify a field that exists in a table different from the current table.

Example 1 

FieldComment ( "Customers" ; "Phone Number" ) returns "Customer's home telephone number" if it was entered as a comment for the Phone Number field.

Example 2 

FieldComment ( "Customers" ; "Accounts::Current Balance" ) returns "Customer's current balance" if it was entered as a comment for the Current Balance field in the Accounts table.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas