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

FileMaker Pro 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.