Hi,
I have a form. In that i have a subform.
On the subform i have some Text fields and Rich Text Lite fields that need to be hidden if the value of Field A in form is “”.
I am using the hide when formula. All the text fields are hidden based on the formula, but the Rich Text Lite fields are not getting hidden. I am using the same hide when formula for Text fields and Rich Text Lite fields.
Am i doing something wrong.
Any help is greatly appreciated.
Subject: Hiding a Rich Text Lite Field
To hide a richtext (I presume richtext lite is the same for this), you need to use a computed subform, and use the formula @If(FieldA=“”;“”;“yourSubForm”).
But unfortunately this is calculated when the document opens. So if you change the value of your field the subform will not be calculated again…
Renaud
Subject: Hiding a Rich Text Lite Field
add a space before the Rich text field and it will work
Subject: RE: Hiding a Rich Text Lite Field
Thanks Savvas!!! That worked. I guess I have a simple RTF. Just one line. Amazing trick I never knew in all my years of doing this… lol
Subject: RE: Hiding a Rich Text Lite Field
The “add a space” trick is not a reliable method. It only works in trivial cases.
Subject: RE: Hiding a Rich Text Lite Field
That’s right, it will work only for the first line of the richtext ! For instance, if your enter two lines into the richtext the second line will not be hidden !!!
So don’t ever use this method.
Renaud
Subject: RE: Hiding a Rich Text Lite Field
It worked for my case and it was a RT field which contains commnets + attachments. Maybe if it is more complicated case then may not work…