ValueListNames()

ValueListNames()

Category: Design

Syntax: ValueListNames ( fileName )

Parameters: fileName ”a string or text expression that represents the name of an open file.

Description: Returns a carriage return “delimited list of value list names from the specified file.

Examples:

 ValueListNames ( Get (FileName)) 

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

 Phone_Label Location Type Category 

Comments:

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.