If statement in a text box based on selection of field

[#1]

Hi

I would like to know is it possible to create a text box with conditional text.

my text box has a campaign selection field as an input as below:

= ,'Online Sales Report for ' & [CAMPAIGN]  & ' ' & [Year])

but when there is no selection, it shows "Online Sales report for"..... I would like to make this text box conditional so that when there is no selection it remains blank

= if(CAMPAIGN = '' ,'','Online Sales Report ' & [CAMPAIGN]  & ' ' & [Year])

I am using the above statement but it does not seem to work

[Anonymous]

Hi Taahir,

Go to layout check conditional and give condition GetSelectedCount(Campaign)>1.

[sunny_talwar]

May be like this

If(GetSelectedCount(CAMPAIGN) = 1, 'Online Sales Report for ' & [CAMPAIGN]  & ' ' & [Year])

[Anonymous]

Or if i got you wrong and you need the text box to be displayed but as empty,

use the same trick

if( GetSelectedCount(Campaign)>1,<your string>)

[#5]

Thanks Sunny your solution helped

[#6]

Thanks Shiva your solution worked as well