[David Wedding]

I have a database with a number of option fields that I want to
include in a word merge document. I have no trouble with regular
fields or checkboxes, but I need some advice on transfering option
values to the same type of formated form on the word template as on my
database. Should I be using VBA code to do this?

Thanks,

PC

[Doug Robbins - Word MVP]

What do you mean by "option fields"?

--
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

"David Wedding" wrote in message
...
I have a database with a number of option fields that I want to
include in a word merge document. I have no trouble with regular
fields or checkboxes, but I need some advice on transfering option
values to the same type of formated form on the word template as on my
database. Should I be using VBA code to do this?

Thanks,

PC

[PC User]

An option field is a field in a table that gets its value from an
option group on a form. The option group consists of a frame with
checkboxes, radio buttons, toggle buttons, etc. that are choices that
are mutually exclusive. The option value comes from the frame, not
the checkboxes or buttons. If there are 12 checkboxes and one of them
is selected, then the option group's value is a number corresponding
to the checkbox's option value. The checkbox is not independent, but
a part of the group and the selected checkbox gives its value to the
group. Hence there could be 12 possible values transfered to the MS
Word template, but only one of the twelve can be transfered.

This is a control in MS Access and I'm trying to find out if MS Word
has a similar control so that I can merge that option value like the
other field values are done during a word merge process. The
description of an option is given in the MS Access help:

Each control (control: A graphical user interface object, such as a
text box, check box, scroll bar, or command button, that lets users
control the program. You use controls to display data or choices,
perform an action, or make the user interface easier to read.) in an
option group (option group: A frame that can contain check boxes,
toggle buttons, and option buttons on a form, report, or data access
page. You use an option group to present alternatives from which the
user can select a single option.) has a numeric value that you can set
with the OptionValue property. Read/write Long.

The OptionValue property applies only to the check box (check box: A
control that indicates whether an option is selected. A check mark
appears in the box when the option is selected.), option button
(option button: A control, also called a radio button, that is
typically used as part of an option group to present alternatives on a
form, report, or data access page. The user cannot select more than
one option.), and toggle button (toggle button: A control that is used
to provide on/off options on a form or report. It can display either
text or a picture and can be stand-alone or part of an option group.)
controls in an option group.

So far I've seen two methods of processing a word merge: 1) merging
the fields and 2) using bookmark fields. However, my research is far
from done; so any help on this would be appreciated. Thanks so much
for your inquiry.

[Doug Robbins - Word MVP]

OK so as far as the field type in the table definition, the field that is
populated by selecting the option is probably either a Text field or a
Number field and it should not make any difference to the mail merge process
how that field is populated.

--
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

"PC User" wrote in message
...

An option field is a field in a table that gets its value from an
option group on a form. The option group consists of a frame with
checkboxes, radio buttons, toggle buttons, etc. that are choices that
are mutually exclusive. The option value comes from the frame, not
the checkboxes or buttons. If there are 12 checkboxes and one of them
is selected, then the option group's value is a number corresponding
to the checkbox's option value. The checkbox is not independent, but
a part of the group and the selected checkbox gives its value to the
group. Hence there could be 12 possible values transfered to the MS
Word template, but only one of the twelve can be transfered.

This is a control in MS Access and I'm trying to find out if MS Word
has a similar control so that I can merge that option value like the
other field values are done during a word merge process. The
description of an option is given in the MS Access help:

Each control (control: A graphical user interface object, such as a
text box, check box, scroll bar, or command button, that lets users
control the program. You use controls to display data or choices,
perform an action, or make the user interface easier to read.) in an
option group (option group: A frame that can contain check boxes,
toggle buttons, and option buttons on a form, report, or data access
page. You use an option group to present alternatives from which the
user can select a single option.) has a numeric value that you can set
with the OptionValue property. Read/write Long.

The OptionValue property applies only to the check box (check box: A
control that indicates whether an option is selected. A check mark
appears in the box when the option is selected.), option button
(option button: A control, also called a radio button, that is
typically used as part of an option group to present alternatives on a
form, report, or data access page. The user cannot select more than
one option.), and toggle button (toggle button: A control that is used
to provide on/off options on a form or report. It can display either
text or a picture and can be stand-alone or part of an option group.)
controls in an option group.

So far I've seen two methods of processing a word merge: 1) merging
the fields and 2) using bookmark fields. However, my research is far
from done; so any help on this would be appreciated. Thanks so much
for your inquiry.

[PC User]

Thank you for your reply. I would be interested in hearing anyone
else's approach to the problem.

~~ PC

[Doug Robbins - Word MVP]

What is the problem?

What do you mean by "the same type of formated form" from you original post?

What is it that you want to appear in the result of the Mail Merge?

If you look at the table behind the Access form, what data appears in what
you call the "Options Fields"?

--
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

"PC User" wrote in message
...
Thank you for your reply. I would be interested in hearing anyone
else's approach to the problem.

~~ PC