Textobject won't hold more than 6 GetFieldSelections

[#1]

Greetings,

I have a list box which uses the windows checkbox style. As the user selects items, I want them to show in a text object. This works fine with =GetFieldSelections([acct number], ',') in the text formula box as long as the selections do not exceed six [acct number]. Any more selected and the text object displays "7 of 2145". Is there any way to display all of the GetFieldSelections in the text object?

Thanks,

Frank

[Nicole-Smith · Accepted solution]

If you want it to show more than 6, you need to up the max value:

getfieldselections ( FieldName [, ValueSep [, MaxValues]])

Returns a string with the current selections in a field.

ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Examples

getfieldselections ( Year )

getfieldselections ( Year, '; ' )

getfieldselections ( Year, '; ' , 10 )

So in your case (1000 or whatever number you want):

=GetFieldSelections([acct number], ',', 1000)

[#3]

Thank you!