listbox selection inText box,

[#1]

i have a list box name country with multiple country  ,,, how can i crate a text object that when i select multiple countries all the country will show in text object ,,desplay in text object should be top to down .

for ex when i select japan and USA

listbox

japan

USA

UK 

Test object

Japan

USA                      not like Japan USA

[trdandamudi]

May be as below:

=Concat(Distinct Country& chr(13))

[#3]

HI thanks it works but when nothing is selected all country display in text object,, is there way to to some set analysis

thanks

[ger_alegria · Accepted solution]

Use the Function GetFieldSelections, i.e:

=GetFieldSelections(Year)

You will see in your text object the years that you selected.

[ger_alegria]

GetFieldSelections(Field_to_use)

[trdandamudi]

How about the below expression:

=If(GetSelectedCount(Country)>0, Concat(Distinct Country & chr(13)))