View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word Merge Data From MS Access Options Fields

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.