Embed word file in access report ?

I have an access application which generates various invoices , reminders etc. I want to add standard terms and conditions as one more report. Its basically pure text ( no variable) , but is approx 7-8 pages. I can print it separately by opening word everytime but if I can print directly from access that will be great.

I tried to create a new report and add text in text boxes , but it seems getting complicated.

is there easy way to put entire word document in access report and print it easily with all its word formatting.
LVL 1
Vaibhavjoshi2005Asked:
Who is Participating?
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
I generate lots of documents like what you want with Access reports. I generally put no more than one page in each record's memo field. I use a set of tables for Documents to store the text in multiple records. I use a sub report to print the records.

For the field in the table and the text box control did you set the Text Format to Rich Text?

When pasting from Word, I do find that some of the formatting is not compatible and must be re-applied.

Another option would be to have Access print the file after it printe the Access report.

I have done it with PDFs using this:

CreateObject("Shell.Application").Namespace(0).ParseName("c:\mypdf\myDoc.pdf").InvokeVerb ("Print")

Open in new window


I store things like this in PDFs so it can be easily emailed as an attachment. I can save the Access report as a PDF then append the other PDF(s) to it before emailing.


I have not tried it with Word documents but it should work.

EDIT: Just tested it with Word and it works fine
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
If you are using Access 2007 or later then you can store tee text in a table as Rich Text. This will preserve the  formatting.
0
 
Vaibhavjoshi2005Author Commented:
I tried that but it took only first 4 pages in memo field. Then the formatting and font also got changed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.