Conditional text box help

[#1]

I have this scenario

I have a parameter (Client) which can have a lot of fixed values (e.g A, B, C, D, E, F, G).

I have a text box that I want to show when Client = A or B or C or any combination of the 3 (we could have one selected or 2 or 3). The text box will be hidden when any other value is selected.

Any idea how I can do that?

Doing an if(Match(Client,A,B,C),0,1) does not return a 0 when A, B and C are all selected or any combination of 2 of the 3 are selected.

Please advise.

Thanks,
Amit

[sunny_talwar]

May be this as your hide/show condition:

SubStringCount(Concat(DISTINCT Client, '|'), 'A') = 1 or

SubStringCount(Concat(DISTINCT Client, '|'), 'B') = 1 or

SubStringCount(Concat(DISTINCT Client, '|'), 'C') = 1

[Kushal_Chawda]

Write the below expression in Conditional of Layout tab of text object

=if(wildmatch(getfieldselections(Client),'*A*') or

     wildmatch(getfieldselections(Client),'*B*') or

     wildmatch(getfieldselections(Client),'*C*'),1,0)