Access 2007: How do you insert the contents of an Attachment field for a printed report?
Posted on 2007-07-26
Access 2007: How do you insert the contents of your attachments in a report for printing? I have a table with attachments that can be short word documents, excel worksheets, or visio drawings. On screen, I can view them but then it only displays the icon (or a paperclip :) when you print it.
Related question: I can use OLE objects instead of attachments. In that case, I would like to resize the OLE control on the report dynamically and display the object only if it is not Null. How do I dynamically change the size of the OLE control in the report? A code snippet would be welcome.
BTW, the field is optional and not all rows have an object/attachment associated with them.