[Brad Waldron]

In Word is there an equivalent command to the Excel If-Then statement. We have inspection reports that have numerous Yes/No questions. If the Yes box is selected, I am trying to find the best way to bring in a stock statement that would be printed next to that.

Brad

[Brad Waldron]

Originally Posted by Brad Waldron

In Word is there an equivalent command to the Excel If-Then statement. We have inspection reports that have numerous Yes/No questions. If the Yes box is selected, I am trying to find the best way to bring in a stock statement that would be printed next to that.

Brad

After researching this for most of the day, the best solution I have been able to come up with is creating a unique identifier for each question on our inspection report and then using that identifier to create an Autotext entry for the stock statement I want to show up.

If anyone has a better idea or you want to just shoot holes in my plan, I am open to all comments/critiques.

Brad

[Suzanne S. Barnhill]

If you're going to use AutoText anyway, see
http://word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Brad Waldron" wrote in message
...

Brad Waldron;491832 Wrote:
In Word is there an equivalent command to the Excel If-Then statement.
We have inspection reports that have numerous Yes/No questions. If the
Yes box is selected, I am trying to find the best way to bring in a
stock statement that would be printed next to that.

Brad

After researching this for most of the day, the best solution I have
been able to come up with is creating a unique identifier for each
question on our inspection report and then using that identifier to
create an Autotext entry for the stock statement I want to show up.

If anyone has a better idea or you want to just shoot holes in my plan,
I am open to all comments/critiques.

Brad




--
Brad Waldron

[Brad Waldron]

Suzanne,

Thanks for the response. I followed the instructions that you sent and got it to work but now I have more questions.

On the inspection report I am thinking about using this on, we have about 150 questions that our employee must answer. Each question is a simple Yes/No where if the answer is No I need to print a stock comment at the end of that question.

Is there a limit to the number of entries, and the size of each entry, in the AutoTextList?

Would it be better to have one list for the whole document, one list for each section of the report or one list for each question?

It looks like use of either AutoText or AutoTextList creates changes to the normal.dot file which resides on a specific computer. Since we want to be able to use this report on multiple computers, might you have any ideas?

Thanks
Brad
___________________________________________

Originally Posted by Suzanne S. Barnhill

If you're going to use AutoText anyway, see
http://word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Brad Waldron" wrote in message
...

Brad Waldron;491832 Wrote:
In Word is there an equivalent command to the Excel If-Then statement.
We have inspection reports that have numerous Yes/No questions. If the
Yes box is selected, I am trying to find the best way to bring in a
stock statement that would be printed next to that.

Brad

After researching this for most of the day, the best solution I have
been able to come up with is creating a unique identifier for each
question on our inspection report and then using that identifier to
create an Autotext entry for the stock statement I want to show up.

If anyone has a better idea or you want to just shoot holes in my plan,
I am open to all comments/critiques.

Brad




--
Brad Waldron

[Suzanne S. Barnhill]

In order to use the AutoTextList field in a portable document, you must save
the AutoText entries in a document template (not the Normal template) and
create new documents based on that template (which must be available to the
document). Since each AutoTextList is based on a given style, you must have
as many styles as you want lists. There is no limit to the number of entries
on the list, nor is there any practical limit to the length of the AutoText
entry (which can be anything from a single word--even a single letter or
punctuation mark, I suppose--to many paragraphs, fields, tables, etc.).

You don't say what version of Word you have. If you have Word 2007 or 2010,
in which AutoText is implemented differently from Word 2003 and earlier,
this will be a less satisfactory solution.

It may be that you'd be better off using legacy form fields in a protected
form. For Yes/No questions, you can use a check box form field, but
unfortunately Word isn't able to do anything with the result of that field.
If, however, you use a drop-down form field with just the two choices (Yes
and No), then you can use an IF field to add other content based on the
answer. Note that each form field has a built-in bookmark. For a drop-down
field, this will be Dropdown1, Dropdown2, etc., but you can change the
bookmark in the Form Field Options. So let's say that the bookmark name for
a given field is Whatever. The basic format of the IF field would then be as
follows:

{ IF { REF Whatever } = "No" "Stock text you want to print for a negative
answer" }

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Brad Waldron" wrote in message
...

Suzanne,

Thanks for the response. I followed the instructions that you sent and
got it to work but now I have more questions.

On the inspection report I am thinking about using this on, we have
about 150 questions that our employee must answer. Each question is a
simple Yes/No where if the answer is No I need to print a stock comment
at the end of that question.

Is there a limit to the number of entries, and the size of each entry,
in the AutoTextList?

Would it be better to have one list for the whole document, one list for
each section of the report or one list for each question?

It looks like use of either AutoText or AutoTextList creates changes to
the normal.dot file which resides on a specific computer. Since we want
to be able to use this report on multiple computers, might you have any
ideas?

Thanks
Brad
___________________________________________
Suzanne S. Barnhill;491839 Wrote:
If you're going to use AutoText anyway, see
http://word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Brad Waldron" wrote in message
...-

Brad Waldron;491832 Wrote:-
In Word is there an equivalent command to the Excel If-Then statement.
We have inspection reports that have numerous Yes/No questions. If
the
Yes box is selected, I am trying to find the best way to bring in a
stock statement that would be printed next to that.

Brad-

After researching this for most of the day, the best solution I have
been able to come up with is creating a unique identifier for each
question on our inspection report and then using that identifier to
create an Autotext entry for the stock statement I want to show up.

If anyone has a better idea or you want to just shoot holes in my
plan,
I am open to all comments/critiques.

Brad




--
Brad Waldron
-




--
Brad Waldron

[Brad Waldron]

Thanks for all your help Suzanne. It looks like any of the options will not work exactly as I had hoped, but at least there are some choices.

Brad

Originally Posted by Suzanne S. Barnhill

In order to use the AutoTextList field in a portable document, you must save
the AutoText entries in a document template (not the Normal template) and
create new documents based on that template (which must be available to the
document). Since each AutoTextList is based on a given style, you must have
as many styles as you want lists. There is no limit to the number of entries
on the list, nor is there any practical limit to the length of the AutoText
entry (which can be anything from a single word--even a single letter or
punctuation mark, I suppose--to many paragraphs, fields, tables, etc.).

You don't say what version of Word you have. If you have Word 2007 or 2010,
in which AutoText is implemented differently from Word 2003 and earlier,
this will be a less satisfactory solution.

It may be that you'd be better off using legacy form fields in a protected
form. For Yes/No questions, you can use a check box form field, but
unfortunately Word isn't able to do anything with the result of that field.
If, however, you use a drop-down form field with just the two choices (Yes
and No), then you can use an IF field to add other content based on the
answer. Note that each form field has a built-in bookmark. For a drop-down
field, this will be Dropdown1, Dropdown2, etc., but you can change the
bookmark in the Form Field Options. So let's say that the bookmark name for
a given field is Whatever. The basic format of the IF field would then be as
follows:

{ IF { REF Whatever } = "No" "Stock text you want to print for a negative
answer" }

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Brad Waldron" wrote in message
...

Suzanne,

Thanks for the response. I followed the instructions that you sent and
got it to work but now I have more questions.

On the inspection report I am thinking about using this on, we have
about 150 questions that our employee must answer. Each question is a
simple Yes/No where if the answer is No I need to print a stock comment
at the end of that question.

Is there a limit to the number of entries, and the size of each entry,
in the AutoTextList?

Would it be better to have one list for the whole document, one list for
each section of the report or one list for each question?

It looks like use of either AutoText or AutoTextList creates changes to
the normal.dot file which resides on a specific computer. Since we want
to be able to use this report on multiple computers, might you have any
ideas?

Thanks
Brad
___________________________________________
Suzanne S. Barnhill;491839 Wrote:
If you're going to use AutoText anyway, see
http://word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Brad Waldron" wrote in message
...-

Brad Waldron;491832 Wrote:-
In Word is there an equivalent command to the Excel If-Then statement.
We have inspection reports that have numerous Yes/No questions. If
the
Yes box is selected, I am trying to find the best way to bring in a
stock statement that would be printed next to that.

Brad-

After researching this for most of the day, the best solution I have
been able to come up with is creating a unique identifier for each
question on our inspection report and then using that identifier to
create an Autotext entry for the stock statement I want to show up.

If anyone has a better idea or you want to just shoot holes in my
plan,
I am open to all comments/critiques.

Brad




--
Brad Waldron
-




--
Brad Waldron