ValueCount function

Contents > Functions reference (alphabetical list) > Text functions > ValueCount function

ValueCount function

Format


ValueCount(text)

Parameter

text - any text expression or text field

Important See Design functions for information about literal text parameters.

Data type returned

number

Description

Returns a count of the total number of values in text.

Values are text items separated by carriage returns. You can place several items together to create a carriage-return-delimited list of values. A value can be empty, a single character, a word, a sentence, or a paragraph. When you press Return you start creating a new value. The last value will be recognized with or without a carriage return.

When the text parameter is a literal string as in the example below, you must insert a literal carriage return character between each item in the list. In the Specify Calculation dialog box, click the ¶ button to insert a literal carriage return character.

Examples

ValueCount("Item 1¶Item 2¶Item 3") returns 3.

ValueCount(ValueListItems("Employees";"Employee Names") returns the total number of values in the Employee Names value list in the Employees database file.

Related topics

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Contents > Functions reference (alphabetical list) > Text functions > ValueCount function