getfieldselections not returning all selected value

[musketeers]

Hi,

In my list box I have around 200 values. I want to display the values selected in that list box in a Text Box. I am using getfieldselections to get the selected values.

Now for some very few selection Like if 5 values are selected in list box, GetFieldSelections is displaying the indivisual values selected in text box.

Now I have selected 8 values, the function is displaying 8 of 200.

Is there any way we can get all the values selected in the list box.

I am using this function like this:

=GetFieldSelections(Country)

Please help me here.

Thanks

Rajneesh

[Chanty4u]

try thsi

=isnull(GetFieldSelections(Country))

[swuehl]

=GetFieldSelections(Country,', ', 200)

[awhitfield]

You need to specify the MAX value of records returned, the default is 6, check QV help file.

Andy

[sunny_talwar]

You can try this:

=GetFieldSelections(Country, ',', 100000)

or

=If(GetSelectedCount(Country) > 0, Concat(DISTINCT Country, ','))

[Anonymous]

=GetFieldSelections(Country,',',200)

[HirisH_V7]

Hi You can use ,

getcurrentselections (chr(13), '=', ';', 200 )

This will give you the selected fields of all the listboxes like this,

getfieldselections (Customer, ',' , 200 )

This will give only Customer List box,

HTH,

Hirish