Returns the length of the field in a specified position of a table.


FLENGTH(<field number expN> [, <alias>])

<field number expN>

The position of the field whose length you want returned. The first field in a table is field number 1.


The work area you want to check.


FLENGTH( ) returns the length of a field in a table based on the specified <field number expN> parameter. The field length for numeric fields includes the decimal digits and one for the decimal point character. Certain field types have fixed lengths. For example, in a DBF table, FLENGTH( ) returns 8 for date fields and 10 for memo fields.

FLENGTH( ) returns 0 if the table does not contain a field in the specified position.


Check the length property of the Field object.