How to print variable length Word document (less than 1 page) in an Access Report
Posted on 2009-06-29
I have a table that has 2 variable-length objects. The objects need to contain text that has paragraph and font formatting instructions (e.g., paragraph breaks, imbedded bolding, colors on phrases). Most of the time the text objects are less than one page long, but are variable in length, and sometimes exceed one page. I currently have the objects as imbedded OLE Objects containing Word document "snippets". The problem with this approach is that you can't size the OLE Object on a report to grow or shrink based upon the number of lines in each record's text. Is there a way to resize a Word OLE Object on a report? Or, is there a way to save the "snippets" in a Memo field and still keep the paragraph/font formatting information? BTW: I'm not needing to edit the information in the "snippets", just store them and display them on a form and in a report.