Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Help with forms and duplicating input text
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? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Help with forms and duplicating input text
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|FieldREF and adding the formfield's bookmark name; or .. Insert|Cross Referencebookmark 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] "Helen" wrote in message ... | 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? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Help with forms and duplicating input text
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|FieldREF and adding the formfield's bookmark name; or .. Insert|Cross Referencebookmark 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] "Helen" wrote in message ... | 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? |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Help with forms and duplicating input text
On Feb 5, 10:53 am, Helen wrote:
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|FieldREF and adding the formfield's bookmark name; or .. Insert|Cross Referencebookmark 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] "Helen" wrote in ... | 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?- 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 |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Help with forms and duplicating input text
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. "Greg Maxey" wrote: On Feb 5, 10:53 am, Helen wrote: 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|FieldREF and adding the formfield's bookmark name; or .. Insert|Cross Referencebookmark 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] "Helen" wrote in ... | 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?- 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 |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Help with forms and duplicating input text
Macros are not difficult if someone has prepared the code for you - see
http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Helen wrote: 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. "Greg Maxey" wrote: On Feb 5, 10:53 am, Helen wrote: 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|FieldREF and adding the formfield's bookmark name; or .. Insert|Cross Referencebookmark 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] "Helen" wrote in ... 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?- 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 |
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
Help with forms and duplicating input text
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/show...?Number=249902 Cheers -- macropod [MVP - Microsoft Word] "Helen" wrote in message ... | 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|FieldREF and adding the formfield's bookmark name; or | .. Insert|Cross Referencebookmark 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] | | | "Helen" wrote in message ... | | 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? | | | |
#8
Posted to microsoft.public.word.tables
|
|||
|
|||
Help with forms and duplicating input text
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 "macropod" wrote: 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/show...?Number=249902 Cheers -- macropod [MVP - Microsoft Word] "Helen" wrote in message ... | 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|FieldREF and adding the formfield's bookmark name; or | .. Insert|Cross Referencebookmark 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] | | | "Helen" wrote in message ... | | 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? | | | |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicating Contents of Content Controls | Microsoft Word Help | |||
Duplicating Information in Forms | Microsoft Word Help | |||
Duplicating an Entry in a MS Word Form | Microsoft Word Help |