Word Merge - Automatic

[theitman]

Hello. Does anyone know how to take information from a field in Access and
automatically dump it to a Word Document? Here's the situation:
I have a form that is bound to a notes table. There is a comments field in
the table that is of a memo type. The users need to print off the comments
on a regular basis. I'd like to take the comments from the active record and
put them into word and have all this done by a user clicking on a button. Is
this possible?

 

[Van T. Dinh]

Anything wrong with an Access Report printing out comments?

It is certainly possible with Word Automation but it is slightly an overkill
and more complex than designing a simple Access Report.

 

[theitman]

Would the report be able to span 5 pages or more? Sometimes the comments are
a paragraph, sometimes they are 3-4 pages. I figured if I used a text box,
that would limit the size??
------------------

 

[Van T. Dinh]

No. TextBox has the Properties CanGrow and CanShrink that you can use.
TextBox can accomodate upto 64K characters!