Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
Make sure you use the unbound image control and set the Controlsource to the field.
MS Access 2013 OLE object does not display
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Over 2 hours browsing, trying and various YouTube films watched, I have been trying to figure out how to display an OLE object (picture) from my database MS Access 2013 into my forms and reports.
The solution should be simple, but does not work.
When I insert a picture into the OLE object field I should use Create and MS Picture Manager should open, which does not happen as automatically the Paint editor opens. It is not an option to chose "Object Type" (see screenprint) MS Picture Manager. How can I change this to default opening? Or find another solution for this problem?
Microsoft 365 and Office | Access | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
3 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
ScottGem 68,820 Reputation points Volunteer Moderator2016-09-21T09:50:18+00:00 I don't recommend using the OLE Object datatype. This cause the database to bloat.
Instead use an unbound Image control. Store the path to the file in a text field and assign that field as the Controlsource of the image control.
-
Anonymous
2016-09-21T10:17:50+00:00 Dear Scot
Thank you for your recommendation by adding a Text Field and store the link to picture file/folder.
However. Now my progamme displays the file folder name, and not the picture.
Can you pls. explain which Properties I have to change in the Field of the File.
An example or link to a YouTube video would be great.
Kind regards