View Single Post
  #5   Report Post  
Posted to microsoft.public.word.tables
Helen Helen is offline
external usenet poster
 
Posts: 99
Default 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