Limit for GetPossibleValues

[amars]

Hi all,

I am writing a macro in which I make use of GetPossibleValues , like this

set SupervisorNames = ActiveDocument.fields("Supervisor Name").GetPossibleValues

For i = 0 to SupervisorNames.Count -1

but now when I see the debug this macro to see the value of SupervisorNames.Count it is coming as 100 but my actual count of Supervisor names is aroud 400. Is there some limit for the GetPossibleValues or what?

Please help it is urgent.

Regards

Amar

[#2 · Accepted solution]

hi

try this one

set SupervisorNames = ActiveDocument.fields("Supervisor Name").GetPossibleValues ("500")

this will get upto 500 values

regards

Peter

[amars]

Thanks a lot Peter, that solved my problem.

[thierrytt1102]

you saved me life!