Need to view linked document in report

[dagwood]

I would like a portion of a report to be linked to a stored document (Word, Excel, PowerPoint). What is the best way to accomplish this?

[June7]

What do you mean by 'linked'? You want a hyperlink that will open the document in its native program? What do you mean by 'stored'? Is this document embedded in table or external?

[dagwood]

I found an article on OLE object fields. This looks like it will work. But, I need the size (in the Access report) to vary, depending on the original document. There are no grow or shrink properties for this type field. Any ideas?

[June7]

I've dealt with this question before and conclusion was that is limitation of image and ole controls. Need to set size for the largest possible content.

[dagwood]

Thank you. Looking at other options now for document control system.