ValueListNames()

Category: Design

Syntax: ValueListNames ( fileName )

Parameters:

fileNameA string or text expression that represents the name of an open file.

Data type returned: Text

Description:

Returns a carriage returndelimited list of value list names from the specified file.

The order of the list returned by the ValueListNames() function is the same as that in which the value lists are ordered in the Define Value Lists dialog when the order is set to Custom Order. Changing the Custom Order changes the way the results are ordered, but selecting one of the other choices (Creation Order, Source, Value List Name) does not.

Examples:

Function

Results

ValueListNames ( Get (FileName))

Returns a list of value list names from the current file that might look like this:

 

Phone_Label

 

Location

 

Type

 

Category

Категории