Filling in Forms & Changing Text in Protected Document

Hi Expando1,

If there are clear rules as to what text is required when, then a formula field that references the relevant formfield (whose
properties you'd set to 'calculate on exit') can be made to automatically vary the text. For example, say you have a dropdown
formfield named 'Dropdown1', with options, 1 & 2. For such a scenario you could code your formula field(s) as:
{IF{Dropdown1}= 1 "Text when dropdown = 1"}
{IF{Dropdown1}= 1 "Text when dropdown = 2"}
or
{IF{Dropdown1}= 1 "Text when dropdown = 1" "Text when dropdown = 2"}

You can use as many of these as you need, each one having different text output if you like.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


"Expando1" <Expando1 DeleteThis @discussions.microsoft.com> wrote in message news:1D43B2C0-1412-4FBD-A8B3-9D57FAAA1D4C@microsoft.com...
> "Expando1" wrote:
>
>> Is there a way to allow two types of different protections in a
>> template--"Filling in Forms" & "Comments"?
>>
>> My template has areas with fill in fields to be populated by client
>> information & on database info. I then have to alter the accompanying
>> boilerplate text based on that data acquired--meaning some phrases/sentences
>> needs to be modified or deleted and additional text inserted for
>> clarification.
>
> Oh, simple section breaks won't suffice as the fillable fields and the
> related text are not separated from each other discretely. That is, a
> paragraph will have both fillable fields and the related text which will be
> modified conditional on the information those fields contain.

Thanks macropod. I've writen the formula based on the dropdown field but it
doesn't auto-update the dependent text even though i have 'calculate on exit'
checked for the dropdown field. Instead I have to manually click at the
appropriate place in the document where the text should be and click F9 to
have the text inserted. Shouldn't it auto-update to the appropriate text
without me clicking F9? { IF { Dropdown37} = describes "The patient
ruminates and worries when attempting to sleep and is fearful about being
unable to sleep." }

Also, do you know of a way to prevent a page from a document from printing
in the final report. Basically we have one page that's a check box form and
based on which check boxes are selected it determines the appropriate text to
be inserted into the final report. But that check box form doesn't need to
be included in the final hardcopy printout of the document. I guess I can
simply discard that page when it does go to printer, but i'm just wondering
if there's a better approach.

"macropod" wrote:

> Hi Expando1,
>
> If there are clear rules as to what text is required when, then a formula field that references the relevant formfield (whose
> properties you'd set to 'calculate on exit') can be made to automatically vary the text. For example, say you have a dropdown
> formfield named 'Dropdown1', with options, 1 & 2. For such a scenario you could code your formula field(s) as:
> {IF{Dropdown1}= 1 "Text when dropdown = 1"}
> {IF{Dropdown1}= 1 "Text when dropdown = 2"}
> or
> {IF{Dropdown1}= 1 "Text when dropdown = 1" "Text when dropdown = 2"}
>
> You can use as many of these as you need, each one having different text output if you like.
>
> Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
> them from this message.
>
> --
> Cheers
> macropod
> [MVP - Microsoft Word]
>
>
> "Expando1" <Expando1.DeleteThis@discussions.microsoft.com> wrote in message news:1D43B2C0-1412-4FBD-A8B3-9D57FAAA1D4C@microsoft.com...
> > "Expando1" wrote:
> >
> >> Is there a way to allow two types of different protections in a
> >> template--"Filling in Forms" & "Comments"?
> >>
> >> My template has areas with fill in fields to be populated by client
> >> information & on database info. I then have to alter the accompanying
> >> boilerplate text based on that data acquired--meaning some phrases/sentences
> >> needs to be modified or deleted and additional text inserted for
> >> clarification.
> >
> > Oh, simple section breaks won't suffice as the fillable fields and the
> > related text are not separated from each other discretely. That is, a
> > paragraph will have both fillable fields and the related text which will be
> > modified conditional on the information those fields contain.
>
>

Have you protected the document for forms? Also, note that "exit" requires
that you tab out of the form field; just clicking somewhere else with the
mouse won't do it.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Expando1" <Expando1.TakeThisOut@discussions.microsoft.com> wrote in message
news:66E7AD6D-D765-47B1-BFC9-F04C2749731F@microsoft.com...
> Thanks macropod. I've writen the formula based on the dropdown field but
> it
> doesn't auto-update the dependent text even though i have 'calculate on
> exit'
> checked for the dropdown field. Instead I have to manually click at the
> appropriate place in the document where the text should be and click F9 to
> have the text inserted. Shouldn't it auto-update to the appropriate text
> without me clicking F9? { IF { Dropdown37} = describes "The patient
> ruminates and worries when attempting to sleep and is fearful about being
> unable to sleep." }
>
> Also, do you know of a way to prevent a page from a document from printing
> in the final report. Basically we have one page that's a check box form
> and
> based on which check boxes are selected it determines the appropriate text
> to
> be inserted into the final report. But that check box form doesn't need
> to
> be included in the final hardcopy printout of the document. I guess I can
> simply discard that page when it does go to printer, but i'm just
> wondering
> if there's a better approach.
>
> "macropod" wrote:
>
>> Hi Expando1,
>>
>> If there are clear rules as to what text is required when, then a formula
>> field that references the relevant formfield (whose
>> properties you'd set to 'calculate on exit') can be made to automatically
>> vary the text. For example, say you have a dropdown
>> formfield named 'Dropdown1', with options, 1 & 2. For such a scenario you
>> could code your formula field(s) as:
>> {IF{Dropdown1}= 1 "Text when dropdown = 1"}
>> {IF{Dropdown1}= 1 "Text when dropdown = 2"}
>> or
>> {IF{Dropdown1}= 1 "Text when dropdown = 1" "Text when dropdown = 2"}
>>
>> You can use as many of these as you need, each one having different text
>> output if you like.
>>
>> Note: The field brace pairs (ie '{ }') for the above example are created
>> via Ctrl-F9 - you can't simply type them or copy & paste
>> them from this message.
>>
>> --
>> Cheers
>> macropod
>> [MVP - Microsoft Word]
>>
>>
>> "Expando1" <Expando1.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:1D43B2C0-1412-4FBD-A8B3-9D57FAAA1D4C@microsoft.com...
>> > "Expando1" wrote:
>> >
>> >> Is there a way to allow two types of different protections in a
>> >> template--"Filling in Forms" & "Comments"?
>> >>
>> >> My template has areas with fill in fields to be populated by client
>> >> information & on database info. I then have to alter the accompanying
>> >> boilerplate text based on that data acquired--meaning some
>> >> phrases/sentences
>> >> needs to be modified or deleted and additional text inserted for
>> >> clarification.
>> >
>> > Oh, simple section breaks won't suffice as the fillable fields and the
>> > related text are not separated from each other discretely. That is, a
>> > paragraph will have both fillable fields and the related text which
>> > will be
>> > modified conditional on the information those fields contain.
>>
>>

Thanks Suzanne! I was using the mouse to click elsewhere.

Here's another bit I've been struggling with:
I have two text fields that will contain numbers, eg., Text11 & Text12. I
want to show the difference between those numbers in another field, Text13.
I've tried writing { Text13=SUM(Text11-Text12)\#0 } , but I get "Error in
Syntax!" Any ideas what I'm doing wrong and how to write this formula
properly?

"Suzanne S. Barnhill" wrote:

> Have you protected the document for forms? Also, note that "exit" requires
> that you tab out of the form field; just clicking somewhere else with the
> mouse won't do it.
>
> --
> Suzanne S. Barnhill
> Microsoft MVP (Word)
> Words into Type
> Fairhope, Alabama USA
>
> "Expando1" <Expando1.DeleteThis@discussions.microsoft.com> wrote in message
> news:66E7AD6D-D765-47B1-BFC9-F04C2749731F@microsoft.com...
> > Thanks macropod. I've writen the formula based on the dropdown field but
> > it
> > doesn't auto-update the dependent text even though i have 'calculate on
> > exit'
> > checked for the dropdown field. Instead I have to manually click at the
> > appropriate place in the document where the text should be and click F9 to
> > have the text inserted. Shouldn't it auto-update to the appropriate text
> > without me clicking F9? { IF { Dropdown37} = describes "The patient
> > ruminates and worries when attempting to sleep and is fearful about being
> > unable to sleep." }
> >
> > Also, do you know of a way to prevent a page from a document from printing
> > in the final report. Basically we have one page that's a check box form
> > and
> > based on which check boxes are selected it determines the appropriate text
> > to
> > be inserted into the final report. But that check box form doesn't need
> > to
> > be included in the final hardcopy printout of the document. I guess I can
> > simply discard that page when it does go to printer, but i'm just
> > wondering
> > if there's a better approach.
> >
> > "macropod" wrote:
> >
> >> Hi Expando1,
> >>
> >> If there are clear rules as to what text is required when, then a formula
> >> field that references the relevant formfield (whose
> >> properties you'd set to 'calculate on exit') can be made to automatically
> >> vary the text. For example, say you have a dropdown
> >> formfield named 'Dropdown1', with options, 1 & 2. For such a scenario you
> >> could code your formula field(s) as:
> >> {IF{Dropdown1}= 1 "Text when dropdown = 1"}
> >> {IF{Dropdown1}= 1 "Text when dropdown = 2"}
> >> or
> >> {IF{Dropdown1}= 1 "Text when dropdown = 1" "Text when dropdown = 2"}
> >>
> >> You can use as many of these as you need, each one having different text
> >> output if you like.
> >>
> >> Note: The field brace pairs (ie '{ }') for the above example are created
> >> via Ctrl-F9 - you can't simply type them or copy & paste
> >> them from this message.
> >>
> >> --
> >> Cheers
> >> macropod
> >> [MVP - Microsoft Word]
> >>
> >>
> >> "Expando1" <Expando1.DeleteThis@discussions.microsoft.com> wrote in message
> >> news:1D43B2C0-1412-4FBD-A8B3-9D57FAAA1D4C@microsoft.com...
> >> > "Expando1" wrote:
> >> >
> >> >> Is there a way to allow two types of different protections in a
> >> >> template--"Filling in Forms" & "Comments"?
> >> >>
> >> >> My template has areas with fill in fields to be populated by client
> >> >> information & on database info. I then have to alter the accompanying
> >> >> boilerplate text based on that data acquired--meaning some
> >> >> phrases/sentences
> >> >> needs to be modified or deleted and additional text inserted for
> >> >> clarification.
> >> >
> >> > Oh, simple section breaks won't suffice as the fillable fields and the
> >> > related text are not separated from each other discretely. That is, a
> >> > paragraph will have both fillable fields and the related text which
> >> > will be
> >> > modified conditional on the information those fields contain.
> >>
> >>
>
>
>

Because your calculated form field IS Text 13, you don't need to reference
it. The formula should be { = Text 11-Text 12 \#0 }

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Expando1" <Expando1 DeleteThis @discussions.microsoft.com> wrote in message
news:9E459070-D55A-411D-B6F8-F2FD41EB8D93@microsoft.com...
> Thanks Suzanne! I was using the mouse to click elsewhere.
>
> Here's another bit I've been struggling with:
> I have two text fields that will contain numbers, eg., Text11 & Text12. I
> want to show the difference between those numbers in another field,
> Text13.
> I've tried writing { Text13=SUM(Text11-Text12)\#0 } , but I get "Error in
> Syntax!" Any ideas what I'm doing wrong and how to write this formula
> properly?
>
> "Suzanne S. Barnhill" wrote:
>
>> Have you protected the document for forms? Also, note that "exit"
>> requires
>> that you tab out of the form field; just clicking somewhere else with the
>> mouse won't do it.
>>
>> --
>> Suzanne S. Barnhill
>> Microsoft MVP (Word)
>> Words into Type
>> Fairhope, Alabama USA
>>
>> "Expando1" <Expando1 DeleteThis @discussions.microsoft.com> wrote in message
>> news:66E7AD6D-D765-47B1-BFC9-F04C2749731F@microsoft.com...
>> > Thanks macropod. I've writen the formula based on the dropdown field
>> > but
>> > it
>> > doesn't auto-update the dependent text even though i have 'calculate on
>> > exit'
>> > checked for the dropdown field. Instead I have to manually click at
>> > the
>> > appropriate place in the document where the text should be and click F9
>> > to
>> > have the text inserted. Shouldn't it auto-update to the appropriate
>> > text
>> > without me clicking F9? { IF { Dropdown37} = describes "The patient
>> > ruminates and worries when attempting to sleep and is fearful about
>> > being
>> > unable to sleep." }
>> >
>> > Also, do you know of a way to prevent a page from a document from
>> > printing
>> > in the final report. Basically we have one page that's a check box
>> > form
>> > and
>> > based on which check boxes are selected it determines the appropriate
>> > text
>> > to
>> > be inserted into the final report. But that check box form doesn't
>> > need
>> > to
>> > be included in the final hardcopy printout of the document. I guess I
>> > can
>> > simply discard that page when it does go to printer, but i'm just
>> > wondering
>> > if there's a better approach.
>> >
>> > "macropod" wrote:
>> >
>> >> Hi Expando1,
>> >>
>> >> If there are clear rules as to what text is required when, then a
>> >> formula
>> >> field that references the relevant formfield (whose
>> >> properties you'd set to 'calculate on exit') can be made to
>> >> automatically
>> >> vary the text. For example, say you have a dropdown
>> >> formfield named 'Dropdown1', with options, 1 & 2. For such a scenario
>> >> you
>> >> could code your formula field(s) as:
>> >> {IF{Dropdown1}= 1 "Text when dropdown = 1"}
>> >> {IF{Dropdown1}= 1 "Text when dropdown = 2"}
>> >> or
>> >> {IF{Dropdown1}= 1 "Text when dropdown = 1" "Text when dropdown = 2"}
>> >>
>> >> You can use as many of these as you need, each one having different
>> >> text
>> >> output if you like.
>> >>
>> >> Note: The field brace pairs (ie '{ }') for the above example are
>> >> created
>> >> via Ctrl-F9 - you can't simply type them or copy & paste
>> >> them from this message.
>> >>
>> >> --
>> >> Cheers
>> >> macropod
>> >> [MVP - Microsoft Word]
>> >>
>> >>
>> >> "Expando1" <Expando1 DeleteThis @discussions.microsoft.com> wrote in message
>> >> news:1D43B2C0-1412-4FBD-A8B3-9D57FAAA1D4C@microsoft.com...
>> >> > "Expando1" wrote:
>> >> >
>> >> >> Is there a way to allow two types of different protections in a
>> >> >> template--"Filling in Forms" & "Comments"?
>> >> >>
>> >> >> My template has areas with fill in fields to be populated by client
>> >> >> information & on database info. I then have to alter the
>> >> >> accompanying
>> >> >> boilerplate text based on that data acquired--meaning some
>> >> >> phrases/sentences
>> >> >> needs to be modified or deleted and additional text inserted for
>> >> >> clarification.
>> >> >
>> >> > Oh, simple section breaks won't suffice as the fillable fields and
>> >> > the
>> >> > related text are not separated from each other discretely. That is,
>> >> > a
>> >> > paragraph will have both fillable fields and the related text which
>> >> > will be
>> >> > modified conditional on the information those fields contain.
>> >>
>> >>
>>
>>
>>