variable store limit in a macro

[#1]

Hi,

I have the following in a macro:

set

myfield = ActiveDocument.Fields("ACCTNUM").GetPossibleValues()

the field ACCTNUM has more than 300 values, but myfield only have 100, I think there is a limit of values a variable can store.

Does enyone knows a workaround for this problem?

Thank you

[Oleg_Troyansky · Accepted solution]

GetPossibleValues returns up to 100 values by default. You can change the default by adding another parameter:

...GetPossibleValues 10000