[Chris Thacker]

I have created a document that merges with an Access Database. In that
document I have inserted several 'merged' fields. In addition to the merged
fields I have inserted several legacy controls including a drop list, check
box, and text fields. When I merge the document with a particular record
from my database, then edit that specific document I find that although my
check box and drop list controls move over to the new merged document along
with the data from the database, the legacy text box is stripped from the
master document. I am able to insert an active x text field, and protect the
new document to be used as a form but am not able to format or control the
text box behavior so that it will grow with the amount of text entered or be
limited to a text only field, date format field, or a numeric only field as I
could with the legacy text control. Is there a way to merge a document with
legacy controls that does not lose the text box?

[Doug Robbins - Word MVP]

See the article €œCombining FormFields and Mail Merge€� on the following page
of fellow MVP Graham Mayors website:

http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

If that information is of use to you, please do consider contributing to the
maintenance of that website to ensure its continued availability.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Chris Thacker" Chris wrote in message
...
I have created a document that merges with an Access Database. In that
document I have inserted several 'merged' fields. In addition to the
merged
fields I have inserted several legacy controls including a drop list,
check
box, and text fields. When I merge the document with a particular record
from my database, then edit that specific document I find that although my
check box and drop list controls move over to the new merged document
along
with the data from the database, the legacy text box is stripped from the
master document. I am able to insert an active x text field, and protect
the
new document to be used as a form but am not able to format or control the
text box behavior so that it will grow with the amount of text entered or
be
limited to a text only field, date format field, or a numeric only field
as I
could with the legacy text control. Is there a way to merge a document
with
legacy controls that does not lose the text box?

[Chris Thacker[_2_]]

Thank you for the assistance Doug and were I smart enough to understand what
the link is explaining it might well work. However the instructions for a
lay person such as myself kind of go over my head. There was not enough
specific instruction on how to set up the document in the linked page for me
to execute the process as described on MVP Graham Mayor's website.

"Doug Robbins - Word MVP" wrote:

See the article €œCombining FormFields and Mail Merge€� on the following page
of fellow MVP Graham Mayors website:

http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

If that information is of use to you, please do consider contributing to the
maintenance of that website to ensure its continued availability.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Chris Thacker" Chris wrote in message
...
I have created a document that merges with an Access Database. In that
document I have inserted several 'merged' fields. In addition to the
merged
fields I have inserted several legacy controls including a drop list,
check
box, and text fields. When I merge the document with a particular record
from my database, then edit that specific document I find that although my
check box and drop list controls move over to the new merged document
along
with the data from the database, the legacy text box is stripped from the
master document. I am able to insert an active x text field, and protect
the
new document to be used as a form but am not able to format or control the
text box behavior so that it will grow with the amount of text entered or
be
limited to a text only field, date format field, or a numeric only field
as I
could with the legacy text control. Is there a way to merge a document
with
legacy controls that does not lose the text box?

[Graham Mayor]

As the page explains, form fields and mail merge fields are mutually
exclusive. The macros included on the page -
(http://www.gmayor.com/installing_macro.htm explains how to install macros
from listings) convert the mail merge fields to docvariable fields leaving
the form fields and the docvariable fields are populated from the data
source. You therefore end up with a collection of protected forms one for
each record, filled with data specific to the records in your data source
(three fields in the example) and with user fillable form fields.

Attach your data source to the protected form and run the appropriate macro.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Chris Thacker wrote:
Thank you for the assistance Doug and were I smart enough to
understand what the link is explaining it might well work. However
the instructions for a lay person such as myself kind of go over my
head. There was not enough specific instruction on how to set up the
document in the linked page for me to execute the process as
described on MVP Graham Mayor's website.

"Doug Robbins - Word MVP" wrote:

See the article "Combining FormFields and Mail Merge" on the
following page of fellow MVP Graham Mayor's website:

http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

If that information is of use to you, please do consider
contributing to the maintenance of that website to ensure its
continued availability.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Chris Thacker" Chris wrote in
message ...
I have created a document that merges with an Access Database. In
that document I have inserted several 'merged' fields. In addition
to the merged
fields I have inserted several legacy controls including a drop
list, check
box, and text fields. When I merge the document with a particular
record from my database, then edit that specific document I find
that although my check box and drop list controls move over to the
new merged document along
with the data from the database, the legacy text box is stripped
from the master document. I am able to insert an active x text
field, and protect the
new document to be used as a form but am not able to format or
control the text box behavior so that it will grow with the amount
of text entered or be
limited to a text only field, date format field, or a numeric only
field as I
could with the legacy text control. Is there a way to merge a
document with
legacy controls that does not lose the text box?

[Doug Robbins - Word MVP]

With your existing mail merge main document, which you have protected to
allow only the filling in of forms as the active document, in your case, as
your data source is from Access, you would run a macro containing the code
under the heading on the website of Access Data Source.

If you do not know what to do with the code under that heading, see the
following page of that website http://www.gmayor.com/installing_macro.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Chris Thacker" wrote in message
...
Thank you for the assistance Doug and were I smart enough to understand
what
the link is explaining it might well work. However the instructions for a
lay person such as myself kind of go over my head. There was not enough
specific instruction on how to set up the document in the linked page for
me
to execute the process as described on MVP Graham Mayor's website.

"Doug Robbins - Word MVP" wrote:

See the article €œCombining FormFields and Mail Merge€� on the following
page
of fellow MVP Graham Mayors website:

http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

If that information is of use to you, please do consider contributing to
the
maintenance of that website to ensure its continued availability.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Chris Thacker" Chris wrote in
message
...
I have created a document that merges with an Access Database. In that
document I have inserted several 'merged' fields. In addition to the
merged
fields I have inserted several legacy controls including a drop list,
check
box, and text fields. When I merge the document with a particular
record
from my database, then edit that specific document I find that although
my
check box and drop list controls move over to the new merged document
along
with the data from the database, the legacy text box is stripped from
the
master document. I am able to insert an active x text field, and
protect
the
new document to be used as a form but am not able to format or control
the
text box behavior so that it will grow with the amount of text entered
or
be
limited to a text only field, date format field, or a numeric only
field
as I
could with the legacy text control. Is there a way to merge a document
with
legacy controls that does not lose the text box?