Posted 3 August 2017, 3:23 pm ESTIs it in any way possible to change the value of a textbox based on the InitialToggleState of another textbox?
I have TextBox1 on row 1 in table with a toggle.
On the same row of the table, i have TextBox2 that contains a normal text value.
Is it in any way possible to change the value of TextBox2 based on the InitialToggleState of TextBox1?
So if the ToggleState of TextBox1 is "Collapsed" i want it to show "Count" and when the Togglestate is "Expanded" i want it to show "TotalCount"
I tried a few IIF things like; =IIF( ReportItems!TextBox1.ToggleState ="Collapsed","Total","TotalCount") and =IIF( ReportItems!TextBox1.InitialToggleState ="Collapsed","Total","TotalCount") but they don't seem to work.
Any help would be greatly appreciated.
Thanks in Advance.