Is there something better than ActiveX textboxes?

[Hunter57]

Hi,

I do most of my programming with Access and some in Outlook but I am do not
know much about Word. I am working on a small project to use a Word Document
can be emailed to a person. They fill in textboxes, checkboxes, and
comboboxes in the Document and email it back to the sender.

I have developed a Word Document that uses InlineShapes from the toolbox
ActiveX controls. My code in Access loops through the InlineShapes and
stores the values in a Table. It works quite well. But I am wondering if
there is a better way to do this. Do the ActiveX controls lead to broken
Library References? What are the Pros and Cons? Would a UserForm be better?

Thanks in advance for your help,
Patrick Wood

 

[Jonathan West]

I would recommend using instead checkboxes, textboxes and dropdown listboxes
from the Forms toolbar. Once the layout of the document has been finalised,
go to Tools, Protect Document. Then on the taskpane that appears on the
right, set the Editing restrictions to Filling in Forms, and then save the
document.

Each formfield can be given a meaningful name and that name can be used to
identify it as a specific member of the FormFields collection of the
document. Your Access code then then manipulate the properties of each
FormField object in the document.

 

[Hunter57]

Thank you for your quick and helpful reply, Jonathan. It sounds like just
what I need.

Best Regards,
Patrick Wood
http://gainingaccess.net