ValuesCount Property

The ValuesCount property returns the number of values set for the prompt.

Syntax

Prompt .ValuesCount

Applies To

Prompt Object

Discussion

This property can be used to iterate through the prompt values in conjunction with the CurrentValueIndex property.

A COM exception is thrown in error situations. The message that is passed with the exception varies depending on the error situation.

Type

Integer

Access

Read

Examples

new_report = model.Reports.Add()new_query 
= new_report.Queries.Add()new_prompt.CurrentValueIndex
= indexFor index = 1 To new_prompt.ValuesCount