How do I remove display of the file name of an ole object in acces

[Guest]

I added an OLE object as a field to a table in my Access database. I want to
display the bitmap image on a form. However, when I insert the object into
the field, it displays the image as well as the file name. Can I remove the
file name from the display?

 

[Guest]

Hi,
scrap the ole field. You should NOT store images in Access. It will create
massive bloat.
You should instead use a text datatype field which stores the full path to
the external file. You can then use this path at runtime on forms/reports to
display your images.
For a good tutorial check this:
http://www.databasedev.co.uk/bound_image_form.html
HTH
Good luck

 

[Guest]

Oliver,

Thank you very much. Beause of that data involved, bloat may have become an
issue at a later time, so this was an elegant solution.

By the way, if I do it this way, can I link to files of other formats (JPG,
TIFF, PDF)?

 

[Guest]

You're welcome.
It depends...if you have the Office Graphic Filters installed then yes you
can...transperant and animated gifs are an issue, but there are workarounds.
If you do not have the filters installed, then either do so or check this
solution:
http://www.lebans.com/loadjpeggif.htm
HTH
Good luck