G
Guest
I am trying to link form fields with a Word document so that I can enter a
value into a field, and it populates other fields on the form.
value into a field, and it populates other fields on the form.
macropod said:Hi David,
Instead of linking the formfields (which is quite simple), why not use cross-references to their bookmark names
(Insert|Cross-Reference > Bookmark), or create a formula field (Insert|Field > Formula) if you're trying to do maths?
To link one formfield to another, simply set its type to 'calculation' and insert the relevant equation (referencing the source
formfields) or, for text, use REF Text1 (where 'Text1' is the source formfield's name.
--
Cheers
macropod
[Microsoft MVP - Word]
David said:Aren't there any proper help files for Microsoft products anymore? I opened
help, clicked on 'Can I link form fields within a word document?' and got
sent to this discussion group which then has links to other sites with
vaguely related stuff, most of which is out of date. If I just wanted a bunch
of links related to the topic I could just Google it. Is there anywhere I can
find proper help files or a manual?
macropod said:Hi David,
Instead of linking the formfields (which is quite simple), why not use cross-references to their bookmark names
(Insert|Cross-Reference > Bookmark), or create a formula field (Insert|Field > Formula) if you're trying to do maths?
To link one formfield to another, simply set its type to 'calculation' and insert the relevant equation (referencing the source
formfields) or, for text, use REF Text1 (where 'Text1' is the source formfield's name.
--
Cheers
macropod
[Microsoft MVP - Word]
David said:Aren't there any proper help files for Microsoft products anymore? I opened
help, clicked on 'Can I link form fields within a word document?' and got
sent to this discussion group which then has links to other sites with
vaguely related stuff, most of which is out of date. If I just wanted a bunch
of links related to the topic I could just Google it. Is there anywhere I can
find proper help files or a manual?
i.t.''s nightmare said:Macropod,
Figured it out! Would help if I check the box stating Calclate on
Exit.
Thanks!
macropod said:Hi David,
Instead of linking the formfields (which is quite simple), why not
use cross-references to their bookmark names (Insert|Cross-Referenceyou're trying to do maths?Bookmark), or create a formula field (Insert|Field > Formula) if
To link one formfield to another, simply set its type to
'calculation' and insert the relevant equation (referencing the
source formfields) or, for text, use REF Text1 (where 'Text1' is the
source formfield's name.
--
Cheers
macropod
[Microsoft MVP - Word]
David said:Aren't there any proper help files for Microsoft products anymore?
I opened help, clicked on 'Can I link form fields within a word
document?' and got sent to this discussion group which then has
links to other sites with vaguely related stuff, most of which is
out of date. If I just wanted a bunch of links related to the topic
I could just Google it. Is there anywhere I can find proper help
files or a manual?
Hi David,
Instead of linking the formfields (which is quite simple), why not use cross-references to their bookmark names
(Insert|Cross-Reference > Bookmark), or create a formula field (Insert|Field > Formula) if you're trying to do maths?
To link one formfield to another, simply set its type to 'calculation' and insert the relevant equation (referencing the source
formfields) or, for text, use REF Text1 (where 'Text1' is the source formfield's name.
--
Cheers
macropod
[Microsoft MVP - Word]
David said:Aren't there any proper help files for Microsoft products anymore? I opened
help, clicked on 'Can I link form fields within a word document?' and got
sent to this discussion group which then has links to other sites with
vaguely related stuff, most of which is out of date. If I just wanted a bunch
of links related to the topic I could just Google it. Is there anywhere I can
find proper help files or a manual?
Peter Hansen said:I would like to get some help myself and I saw macropod's name and
remembered
that he had helped me before: I just upgraded from office professional
2003
to office professional 2007. I had created a form in Word 2003 with
cross-references and bookmark names that worked great. In order to move
from
one form field to the next I would hit "tab." But, in order to do so, I
had
to do something first like lock the document or lock the fields, otherwise
by
hitting tab I just rearranged the form by pushing the form field to the
right
instead of going into the next field so that I could type in it. I can't
seem to find the same button to hit in order to lock the document so that
I
can tab through and enter the information in the various fields. How do I
do
this in Word 2007?
"macropod"
Hi David,
Instead of linking the formfields (which is quite simple), why not use
cross-references to their bookmark names
(Insert|Cross-Reference > Bookmark), or create a formula field
(Insert|Field > Formula) if you're trying to do maths?
To link one formfield to another, simply set its type to 'calculation'
and insert the relevant equation (referencing the source
formfields) or, for text, use REF Text1 (where 'Text1' is the source
formfield's name.
--
Cheers
macropod
[Microsoft MVP - Word]
David said:Aren't there any proper help files for Microsoft products anymore? I
opened
help, clicked on 'Can I link form fields within a word document?' and
got
sent to this discussion group which then has links to other sites with
vaguely related stuff, most of which is out of date. If I just wanted a
bunch
of links related to the topic I could just Google it. Is there anywhere
I can
find proper help files or a manual?
You have to protect the document, and Word 2007 does make this unnecessarily
difficult. If you plan to be working with form fields, you need to first
enable the Developer tab, which you do by checking the box for "Show
Developer tab in the Ribbon" in Office Button | Word Options | Popular.
Then, on the Developer tab, you will see, in the Controls group, a button
for Legacy Tools, which opens some palettes that include the Legacy Forms
tools. Alas, the padlock button to lock/unlock forms is not among that group
(though you can add it to the QAT; it's under All Commands as Lock).
Instead, you must use Developer | Protect Document | Restrict Formatting and
Editing, which will open the Protect Document task pane, in which you must
check "2. Editing restrictions," then select "Filling in forms," then click
"Yes, Start Enforcing Protection." Whew!
To be fair, you can access the same Protect Document button (and the task
pane) from the Protect group on the far right end of the Review tab, but you
do need to add the Developer tab if you're actually going to be creating new
forms using the legacy form fields (or, for that matter, the new content
controls).
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
Peter Hansen said:I would like to get some help myself and I saw macropod's name and
remembered
that he had helped me before: I just upgraded from office professional
2003
to office professional 2007. I had created a form in Word 2003 with
cross-references and bookmark names that worked great. In order to move
from
one form field to the next I would hit "tab." But, in order to do so, I
had
to do something first like lock the document or lock the fields, otherwise
by
hitting tab I just rearranged the form by pushing the form field to the
right
instead of going into the next field so that I could type in it. I can't
seem to find the same button to hit in order to lock the document so that
I
can tab through and enter the information in the various fields. How do I
do
this in Word 2007?
"macropod"
Hi David,
Instead of linking the formfields (which is quite simple), why not use
cross-references to their bookmark names
(Insert|Cross-Reference > Bookmark), or create a formula field
(Insert|Field > Formula) if you're trying to do maths?
To link one formfield to another, simply set its type to 'calculation'
and insert the relevant equation (referencing the source
formfields) or, for text, use REF Text1 (where 'Text1' is the source
formfield's name.
--
Cheers
macropod
[Microsoft MVP - Word]
Aren't there any proper help files for Microsoft products anymore? I
opened
help, clicked on 'Can I link form fields within a word document?' and
got
sent to this discussion group which then has links to other sites with
vaguely related stuff, most of which is out of date. If I just wanted a
bunch
of links related to the topic I could just Google it. Is there anywhere
I can
find proper help files or a manual?
Jay Freedman said:There is a simpler way for just protecting and unprotecting forms that
already exist. In Word 2007, go to Office button > Word Options >
Customize. Set the category dropdown to Commands Not in the Ribbon.
Select the Lock command and click the Add button to put it on the
Quick Access Toolbar. The Lock button toggles forms protection, just
like the one on the Forms toolbar in Word 2003.
--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
You have to protect the document, and Word 2007 does make this
unnecessarily
difficult. If you plan to be working with form fields, you need to first
enable the Developer tab, which you do by checking the box for "Show
Developer tab in the Ribbon" in Office Button | Word Options | Popular.
Then, on the Developer tab, you will see, in the Controls group, a button
for Legacy Tools, which opens some palettes that include the Legacy Forms
tools. Alas, the padlock button to lock/unlock forms is not among that
group
(though you can add it to the QAT; it's under All Commands as Lock).
Instead, you must use Developer | Protect Document | Restrict Formatting
and
Editing, which will open the Protect Document task pane, in which you must
check "2. Editing restrictions," then select "Filling in forms," then
click
"Yes, Start Enforcing Protection." Whew!
To be fair, you can access the same Protect Document button (and the task
pane) from the Protect group on the far right end of the Review tab, but
you
do need to add the Developer tab if you're actually going to be creating
new
forms using the legacy form fields (or, for that matter, the new content
controls).
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
Peter Hansen said:I would like to get some help myself and I saw macropod's name and
remembered
that he had helped me before: I just upgraded from office professional
2003
to office professional 2007. I had created a form in Word 2003 with
cross-references and bookmark names that worked great. In order to move
from
one form field to the next I would hit "tab." But, in order to do so, I
had
to do something first like lock the document or lock the fields,
otherwise
by
hitting tab I just rearranged the form by pushing the form field to the
right
instead of going into the next field so that I could type in it. I
can't
seem to find the same button to hit in order to lock the document so
that
I
can tab through and enter the information in the various fields. How do
I
do
this in Word 2007?
"macropod"
Hi David,
Instead of linking the formfields (which is quite simple), why not use
cross-references to their bookmark names
(Insert|Cross-Reference > Bookmark), or create a formula field
(Insert|Field > Formula) if you're trying to do maths?
To link one formfield to another, simply set its type to 'calculation'
and insert the relevant equation (referencing the source
formfields) or, for text, use REF Text1 (where 'Text1' is the source
formfield's name.
--
Cheers
macropod
[Microsoft MVP - Word]
Aren't there any proper help files for Microsoft products anymore? I
opened
help, clicked on 'Can I link form fields within a word document?' and
got
sent to this discussion group which then has links to other sites
with
vaguely related stuff, most of which is out of date. If I just wanted
a
bunch
of links related to the topic I could just Google it. Is there
anywhere
I can
find proper help files or a manual?
That would be the part where I said, "though you can add it to the
QAT; it's under All Commands as Lock." <g>
Jay Freedman said:There is a simpler way for just protecting and unprotecting forms
that already exist. In Word 2007, go to Office button > Word OptionsSelect the Lock command and click the Add button to put it on theCustomize. Set the category dropdown to Commands Not in the Ribbon.
Quick Access Toolbar. The Lock button toggles forms protection, just
like the one on the Forms toolbar in Word 2003.
--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
You have to protect the document, and Word 2007 does make this
unnecessarily
difficult. If you plan to be working with form fields, you need to
first enable the Developer tab, which you do by checking the box
for "Show Developer tab in the Ribbon" in Office Button | Word
Options | Popular. Then, on the Developer tab, you will see, in the
Controls group, a
button for Legacy Tools, which opens some palettes that include the
Legacy Forms tools. Alas, the padlock button to lock/unlock forms
is not among that group
(though you can add it to the QAT; it's under All Commands as Lock).
Instead, you must use Developer | Protect Document | Restrict
Formatting and
Editing, which will open the Protect Document task pane, in which
you must check "2. Editing restrictions," then select "Filling in
forms," then click
"Yes, Start Enforcing Protection." Whew!
To be fair, you can access the same Protect Document button (and
the task pane) from the Protect group on the far right end of the
Review tab, but you
do need to add the Developer tab if you're actually going to be
creating new
forms using the legacy form fields (or, for that matter, the new
content controls).
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
message I would like to get some help myself and I saw macropod's name and
remembered
that he had helped me before: I just upgraded from office
professional 2003
to office professional 2007. I had created a form in Word 2003 with
cross-references and bookmark names that worked great. In order to
move from
one form field to the next I would hit "tab." But, in order to do
so, I had
to do something first like lock the document or lock the fields,
otherwise
by
hitting tab I just rearranged the form by pushing the form field
to the right
instead of going into the next field so that I could type in it. I
can't
seem to find the same button to hit in order to lock the document
so that
I
can tab through and enter the information in the various fields. How do
I
do
this in Word 2007?
"macropod"
Hi David,
Instead of linking the formfields (which is quite simple), why
not use cross-references to their bookmark names
(Insert|Cross-Reference > Bookmark), or create a formula field
(Insert|Field > Formula) if you're trying to do maths?
To link one formfield to another, simply set its type to
'calculation' and insert the relevant equation (referencing the
source formfields) or, for text, use REF Text1 (where 'Text1' is the
source formfield's name.
--
Cheers
macropod
[Microsoft MVP - Word]
Aren't there any proper help files for Microsoft products
anymore? I opened
help, clicked on 'Can I link form fields within a word
document?' and got
sent to this discussion group which then has links to other
sites with
vaguely related stuff, most of which is out of date. If I just
wanted a
bunch
of links related to the topic I could just Google it. Is there
anywhere
I can
find proper help files or a manual?
Graham Mayor said:Better still install Greg Maxey's add-in which restores the familiar Forms
toolbar commands to the Developer Tab
http://gregmaxey.mvps.org/Classic Form Controls.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
That would be the part where I said, "though you can add it to the
QAT; it's under All Commands as Lock." <g>
Jay Freedman said:There is a simpler way for just protecting and unprotecting forms
that already exist. In Word 2007, go to Office button > Word Options
Customize. Set the category dropdown to Commands Not in the Ribbon.
Select the Lock command and click the Add button to put it on the
Quick Access Toolbar. The Lock button toggles forms protection, just
like the one on the Forms toolbar in Word 2003.
--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
On Tue, 22 Sep 2009 20:55:50 -0500, "Suzanne S. Barnhill"
You have to protect the document, and Word 2007 does make this
unnecessarily
difficult. If you plan to be working with form fields, you need to
first enable the Developer tab, which you do by checking the box
for "Show Developer tab in the Ribbon" in Office Button | Word
Options | Popular. Then, on the Developer tab, you will see, in the
Controls group, a
button for Legacy Tools, which opens some palettes that include the
Legacy Forms tools. Alas, the padlock button to lock/unlock forms
is not among that group
(though you can add it to the QAT; it's under All Commands as Lock).
Instead, you must use Developer | Protect Document | Restrict
Formatting and
Editing, which will open the Protect Document task pane, in which
you must check "2. Editing restrictions," then select "Filling in
forms," then click
"Yes, Start Enforcing Protection." Whew!
To be fair, you can access the same Protect Document button (and
the task pane) from the Protect group on the far right end of the
Review tab, but you
do need to add the Developer tab if you're actually going to be
creating new
forms using the legacy form fields (or, for that matter, the new
content controls).
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
message I would like to get some help myself and I saw macropod's name and
remembered
that he had helped me before: I just upgraded from office
professional 2003
to office professional 2007. I had created a form in Word 2003 with
cross-references and bookmark names that worked great. In order to
move from
one form field to the next I would hit "tab." But, in order to do
so, I had
to do something first like lock the document or lock the fields,
otherwise
by
hitting tab I just rearranged the form by pushing the form field
to the right
instead of going into the next field so that I could type in it. I
can't
seem to find the same button to hit in order to lock the document
so that
I
can tab through and enter the information in the various fields. How
do I
do
this in Word 2007?
"macropod"
Hi David,
Instead of linking the formfields (which is quite simple), why
not use cross-references to their bookmark names
(Insert|Cross-Reference > Bookmark), or create a formula field
(Insert|Field > Formula) if you're trying to do maths?
To link one formfield to another, simply set its type to
'calculation' and insert the relevant equation (referencing the
source formfields) or, for text, use REF Text1 (where 'Text1' is the
source formfield's name.
--
Cheers
macropod
[Microsoft MVP - Word]
Aren't there any proper help files for Microsoft products
anymore? I opened
help, clicked on 'Can I link form fields within a word
document?' and got
sent to this discussion group which then has links to other
sites with
vaguely related stuff, most of which is out of date. If I just
wanted a
bunch
of links related to the topic I could just Google it. Is there
anywhere
I can
find proper help files or a manual?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.