Access/Word Automation and Option Group

[belsha]

I have a Word template that opens in Access, populates, prints, and closes perfectly. I would like to know if there is a way to handle option groups for this process. On the form, I have an option group for "reason for selection" (checkbox, one only of course). In the table this is a number field using a lookup to another table with the list of reasons. Same question for Y/N fields, is there some way to tell Word to put an "X" in the appropriate checkbox on the template, or at least to print out the text of the choice selected? Thanks!

 

[belsha]

I have solved the problem with the option groups by using the lookup table description field (a text field) in my query that the form using automation is based on. Doesn't check the box but does display the text associated with the box that was checked. Still would like to know a way to do the checkboxes (Y/N fields which display as -1, 0 in the table/query). I could change the table value to number and have a lookup table with 0=No and 1=Yes, but I have several places where this table is used already and hate to have to change all those areas. Instead of having the value (-1,0) display in the printout using the Word template, I would like to see a "Yes" or "No". I know this has been addressed for Access, but since I am using the automation with Word, I am not sure the best way to handle this. Thanks.