Reference > Functions reference > Design functions > FieldRepetitions
 

FieldRepetitions

Returns the number and orientation of repetitions of a repeating field as formatted on a layout.

Format 

FieldRepetitions ( fileName ; layoutName ; fieldName )

Parameters 

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

layoutName - the name of a layout in the specified file.

fieldName - the name of a field on the specified layout.

Data type returned 

text

Originated in version 

6.0 or earlier

Description 

This function returns the number of repetitions of a repeating field as it is currently formatted on a layout, and the orientation of the field repetitions (horizontal or vertical).

The number of repetitions of fieldName as it is currently formatted could be different from the number of repetitions when the field was defined. If fieldName isn’t a repeating field, it returns 1 vertical.

Example 1 

FieldRepetitions ( "Customers" ; "Data Entry" ; "Business Phone" ) returns 3 vertical if the Business Phone field is defined as a repeating field with five repetitions but is formatted to only show three repetitions in a vertical orientation on the Data Entry layout.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas