Functions Reference

Chapter 4
|
Design functions 37
Examples
To determine whether “Customers” is one of the files currently open, use the
DatabaseNames function with the FilterValues function in the formula:
FilterValues( DatabaseNames;"Customers")
If the formula returns any text value, then “Customers” is open.
If you want to know how many files with the same name are open, use the
DatabaseNames function with the PatternCount function in the formula:
PatternCount(FilterValues(DatabaseNames;"Customers");"Customers")
This will tell you how many files called “Customers” are open.
FieldBounds
Format
FieldBounds(fileName;layoutName;fieldName)
Parameters
fileName - the name of an open database file (local or remote).
layoutName - the name of a layout in the specified database file.
fieldName - the name of a field on the specified layout.
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text
Description
Returns in a non-repeating text field the location in pixels of each side of fieldName and
its rotation in degrees on layoutName in the fileName file. The location is measured from
the top left corner of the layout (regardless of printer margins) and is specified in this order:
position of left field boundary, position of top field boundary, position of right field
boundary, position of bottom field boundary, degree of rotation (measured in a counter-
clockwise direction; 0 degrees for unrotated).
Note Your layout begins where your margins end. Because field boundaries are measured
from the left side and top of the layout, boundaries returned by FieldBounds never
change unless you move or re-size a field.