Hello Please Help what i want is if a checkbox is ticked the Subscribed and Sworn will be cleared in the textfield 

Sorry, but your question is not clear.  

 

Do you want to clear a text field if a checkbox is ticked?  Perhaps you should  use "button setup"  or a script trigger to fire script when the checkbox is changed.  

is there a way to use this using a text field with calculation

See if this helps you along.

 

Case (

YourCheckbox = "" ;

YourTextField ; Substitute ( YourTextField ;

["Sworn " ; ""] ;

[ "Subscribed " ; "" ]

)

)

By the way this is the full text "SUBSCRIBED AND SWORN to before me on"

is this the right calculation

 

Case (

YourCheckbox = "" ;

YourTextField ; Substitute ( YourTextField ;

["SUBSCRIBED AND SWORN to before me on" ; ""] ;

)

Is there a question in there somewhere, or are you good now?

Hi Chad,

 

It would help if you answered Matthew's question ... do you want to clear the entire field or only that phrase FROM an existing text field which also holds other text?  Some considerations:

• If you want to clear the entire field, you don't need the Substitute() portion.
• If you will never need to manually change that text field other than display that phrase or not then you should use a calculation instead of an auto-enter field.
• If you use an auto-enter calculation you must remember to UNCHECK 'do not replace existing value if any' or it won't update.
• If it contains other text you wish to preserve, the existing calc will remove it which you may not want.
• If this is ONLY for display then you don't need a calculation at all and you can handle it at the layout level with a merge variable or even just a text block.  It is seriously worth considering since every calculation adds to field clutter and bloat.  

So as you can see, the more information you provide, the more valuable our suggestions.  If you fill in a bit more information, we can be sure you get exactly what you need.  Or as Lee asks ... 'are you good'?  

Lee Smith Thanks for this i found a solution for the calculation you gave to me i edit some tweak