display OLE on report

[Guest]

I have created a field that has an OLE Object. This object is not linked to
a file because I want the users to modify the content in a form and maintain
the content in Access, rather than maintaining the master document on a file
linked to a share drive.

I want to also display this information in a report and so I have created a
bound object frame. The problem is that the bound object frame will NOT
shrink or grow and therefore all of the information in the document will NOT
display on the report. How do I make the bound object frame shrink or grow
since the information the users type in could be 1-100 pages?

Thanks for your help!!

 

[Stephen Lebans]

It cannot be done...period. If you are using Word docs inserted as OLE
documents then activate Word and allow the user to print from there.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

How do you activate Word when viewing or printing a report?

Stepping back, do you have any other suggestions on how I can accomplish
what I am after - being able to maintain a word-like document in Access AND
having it appear on a viewed or printed report?

 

[Guest]

(I have not tried this, just an idea...) Since the BOF content can be
virtually any application (Excel, Word, PPT, Picture, etc.), and since they
each have their own quirks (esp. related to printing), why can't one isolate
the OLE on a subreport, develop an event procedure (Open, Activate, ...) that
then executes the .print method for the corresponding application? This will
not produce a seamless "report", but it should provide the needed generality
since you simply rely on each application's print method. And, of course, at
the form level, one can simply CTRL+ENTER the BOF to launch the associated
application directly in a separate window, which then allows you to deal with
it via its own interface.