How to display OLE Object (e.g. Word Doc) on form

S

Steve

Hi,

I have a table where we store excel or word docs in an OLE Object field. (We
get about 25 a year, so I'm not interested in the obvious response that you
shouldn't store docs in access because of limited size... we do not have an
issue with that! ;-) ).

The documents are stored fine, but I have an issue with them when I work
with the data in the docs table on a Form. Very quickly, what I want to do is
to display the document as an icon - so similar to being in Word and
embedding a document and telling Word to show it as an icon.

When I drop a field for the OLE Object field onto the form, I can size the
field on the form as I can any other text box or label etc and edit it's
properties so that I set the [Display Type] property of the object on the
form to be an Icon.

Regardless of whether I set the Display Type as an Icon or not, when I load
the form the object decides it'll stuff the developper (me) & display the
Contents of the document instead = ARGH ONE! I cannot get round this.

Secondly, when it's set to show display type as Content the content isn't
just shown in the sized object I've placed on the form. (Tell a lie, it does
the first time the form is loaded but on all subsequent times I load it it
covers the area mentioned next). Instead it covers the entire space from the
top left of the object to the bottom right of the form = ARGH TWO!!

I'm using Access 2003 SP3. Is this something I can get round or is it a bug
in Access 03?

Any help much appreciated as always!!


Regards,

Steve D
 
S

Steve

GRrrrrrrrrrr.. I have now done this. It doesn't help that the help file on
the subject is blinking well wrong.

In order to change the OLE Object from showing the content of the file on
the form you (oddly) have to do it when the form is running / loaded - not
when it's in design mode.... Very odd, doing it in design mode would be far
more obvious and that's where Help says you make the change but it's not!

Wasn't expecting that but at least I've got this to work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top