Word Merge - Automatic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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??
------------------
 
I didn't realize that the memo field would keep going onto continuous pages.
I thought it would stop at the size I made the field box on the page. It
works perfectly!
Thanks
 
No. TextBox has the Properties CanGrow and CanShrink that you can use.
TextBox can accomodate upto 64K characters!
 
Back
Top