Help with forms and duplicating input text

[Helen]

I am trying to create a template for use with a pre-printed form using a
table. I need to be able apply protection so the layout of the table is not
altered. What I want to do is to be able to have users input information in
one cell that is then duplicated in other cells. I have almost achieved
this, it looks great on the print preview, but when it is printed because the
duplicated data is in a protected part of the form it doesn't print. Is
there any way around this?

 

[macropod]

Hi Helen,

The normal way of duplicating the data would be to set the formfield's properties to 'calculate on exit' and insert REF fields
pointing to the formfield's bookmark. You'd create these via:
.. Insert|Field>REF and adding the formfield's bookmark name; or
.. Insert|Cross Reference>bookmark and selecting the formfield's bookmark name.
In either case, the duplicated data will print unless it's been formatted as hidden text or it doesn't fit within the corresponding
table cell (in which case part of it will be hidden). Protection has no effect on whether the duplicated data is printed.

Cheers

--
macropod
[MVP - Microsoft Word]


| I am trying to create a template for use with a pre-printed form using a
| table. I need to be able apply protection so the layout of the table is not
| altered. What I want to do is to be able to have users input information in
| one cell that is then duplicated in other cells. I have almost achieved
| this, it looks great on the print preview, but when it is printed because the
| duplicated data is in a protected part of the form it doesn't print. Is
| there any way around this?

 

[Helen]

Hi, This is what I have done, I have inserted REF fields, but these do not
print out. Could it be because I have the form set to print data only? This
is necessary as there are words on the form that show what data needs to be
input into the next field, but I don't want them to print out as they are
already on the preprinted form. Thanks for the help!

 

[Greg Maxey]

Hi, This is what I have done, I have inserted REF fields, but these do not
print out. Could it be because I have the form set to print data only? This
is necessary as there are words on the form that show what data needs to be
input into the next field, but I don't want them to print out as they are
already on the preprinted form. Thanks for the help!







- Show quoted text -

Helen,

Printing only formfields will print only the formfileds that are in
your document. Other fields (e.g., REF fields won't be printed.

To do what you want to do (or what I think you want to do), you will
need to have other formfields in your document that will be
automatically filled in based on the input to the primary field.


For example say you have a primary field for entering a person's name
and it is bookmarked "NAME",

You want that name repeated in 2 other places. You will need to
insert formfields at those two places and set "Enabled" to off.
Bookmark 1 field say NameREF1 and the other NameREF2

Now you will need to set a macro to run on exit from the primary name
field. Something like this:

Sub AONExit()
Dim oFF As FormFields
Set oFF = ActiveDocument.FormFields
oFF("NameREF1").Result = oFF("Name").Result
oFF("NameREF2").Result = oFF("Name").Result
End Sub

 

[Helen]

Oh dear, I was hoping no one would mention macros! This is a little bit
beyond my capabilities. I guess I'll just have to enter the data in each
field instead of trying to be too big for my own boots. Thanks for all the
help.

 

[Graham Mayor]

Macros are not difficult if someone has prepared the code for you - see
http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Oh dear, I was hoping no one would mention macros! This is a little
bit beyond my capabilities. I guess I'll just have to enter the data
in each field instead of trying to be too big for my own boots.
Thanks for all the help.

Hi, This is what I have done, I have inserted REF fields, but
these do not print out. Could it be because I have the form set to
print data only? This is necessary as there are words on the form
that show what data needs to be input into the next field, but I
don't want them to print out as they are already on the preprinted
form. Thanks for the help!



:
Hi Helen,

The normal way of duplicating the data would be to set the
formfield's properties to 'calculate on exit' and insert REF
fields pointing to the formfield's bookmark. You'd create these
via: .. Insert|Field>REF and adding the formfield's bookmark name;
or .. Insert|Cross Reference>bookmark and selecting the
formfield's bookmark name.
In either case, the duplicated data will print unless it's been
formatted as hidden text or it doesn't fit within the
corresponding table cell (in which case part of it will be
hidden). Protection has no effect on whether the duplicated data
is printed.

Cheers

--
macropod
[MVP - Microsoft Word]

messageI am trying to create a template for use with a pre-printed form
using a table. I need to be able apply protection so the layout
of the table is not altered. What I want to do is to be able to
have users input information in one cell that is then duplicated
in other cells. I have almost achieved this, it looks great on
the print preview, but when it is printed because the duplicated
data is in a protected part of the form it doesn't print. Is
there any way around this?- Hide quoted text -

- Show quoted text -

Helen,

Printing only formfields will print only the formfileds that are in
your document. Other fields (e.g., REF fields won't be printed.

To do what you want to do (or what I think you want to do), you will
need to have other formfields in your document that will be
automatically filled in based on the input to the primary field.


For example say you have a primary field for entering a person's name
and it is bookmarked "NAME",

You want that name repeated in 2 other places. You will need to
insert formfields at those two places and set "Enabled" to off.
Bookmark 1 field say NameREF1 and the other NameREF2

Now you will need to set a macro to run on exit from the primary name
field. Something like this:

Sub AONExit()
Dim oFF As FormFields
Set oFF = ActiveDocument.FormFields
oFF("NameREF1").Result = oFF("Name").Result
oFF("NameREF2").Result = oFF("Name").Result
End Sub

 

[macropod]

Hi Helen,

It's not necessary to resort to 'Print only data for forms' to hide instructions at print time. For example, if you:
.. format the instructions as hidden text
.. make sure 'All' (under 'formatting marks') is checked in Tools|Options|View
.. make sure 'hidden text' is unchecked in Tools|Options|Print
you'll be able to see the instructions but not have them print.

Alternatively, you can embed the instructions in a field that will hide them at print time. For information on how to do this see my
Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902

Cheers

--
macropod
[MVP - Microsoft Word]


| Hi, This is what I have done, I have inserted REF fields, but these do not
| print out. Could it be because I have the form set to print data only? This
| is necessary as there are words on the form that show what data needs to be
| input into the next field, but I don't want them to print out as they are
| already on the preprinted form. Thanks for the help!
|
| "macropod" wrote:
|
| > Hi Helen,
| >
| > The normal way of duplicating the data would be to set the formfield's properties to 'calculate on exit' and insert REF fields
| > pointing to the formfield's bookmark. You'd create these via:
| > .. Insert|Field>REF and adding the formfield's bookmark name; or
| > .. Insert|Cross Reference>bookmark and selecting the formfield's bookmark name.
| > In either case, the duplicated data will print unless it's been formatted as hidden text or it doesn't fit within the
corresponding
| > table cell (in which case part of it will be hidden). Protection has no effect on whether the duplicated data is printed.
| >
| > Cheers
| >
| > --
| > macropod
| > [MVP - Microsoft Word]
| >
| >
| > | I am trying to create a template for use with a pre-printed form using a
| > | table. I need to be able apply protection so the layout of the table is not
| > | altered. What I want to do is to be able to have users input information in
| > | one cell that is then duplicated in other cells. I have almost achieved
| > | this, it looks great on the print preview, but when it is printed because the
| > | duplicated data is in a protected part of the form it doesn't print. Is
| > | there any way around this?
| >
| >
| >

 

[Helen]

Thanks for all the help guys, I eventually came up with my own solution which
seems to work. I simply set a background colour for the table, put all text
I didn't want printed in white, and set the print options so the background
doesn't print. One day when I'm feeling very brave I will have a look at
macros and try to see what I can do with them. Thanks again.

Helen

Hi Helen,

It's not necessary to resort to 'Print only data for forms' to hide instructions at print time. For example, if you:
.. format the instructions as hidden text
.. make sure 'All' (under 'formatting marks') is checked in Tools|Options|View
.. make sure 'hidden text' is unchecked in Tools|Options|Print
you'll be able to see the instructions but not have them print.

Alternatively, you can embed the instructions in a field that will hide them at print time. For information on how to do this see my
Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902

Cheers

--
macropod
[MVP - Microsoft Word]


| Hi, This is what I have done, I have inserted REF fields, but these do not
| print out. Could it be because I have the form set to print data only? This
| is necessary as there are words on the form that show what data needs to be
| input into the next field, but I don't want them to print out as they are
| already on the preprinted form. Thanks for the help!
|
| "macropod" wrote:
|
| > Hi Helen,
| >
| > The normal way of duplicating the data would be to set the formfield's properties to 'calculate on exit' and insert REF fields
| > pointing to the formfield's bookmark. You'd create these via:
| > .. Insert|Field>REF and adding the formfield's bookmark name; or
| > .. Insert|Cross Reference>bookmark and selecting the formfield's bookmark name.
| > In either case, the duplicated data will print unless it's been formatted as hidden text or it doesn't fit within the
corresponding
| > table cell (in which case part of it will be hidden). Protection has no effect on whether the duplicated data is printed.
| >
| > Cheers
| >
| > --
| > macropod
| > [MVP - Microsoft Word]
| >
| >
| > | I am trying to create a template for use with a pre-printed form using a
| > | table. I need to be able apply protection so the layout of the table is not
| > | altered. What I want to do is to be able to have users input information in
| > | one cell that is then duplicated in other cells. I have almost achieved
| > | this, it looks great on the print preview, but when it is printed because the
| > | duplicated data is in a protected part of the form it doesn't print. Is
| > | there any way around this?
| >
| >
| >