ACCESS Report image not showing

Summary: 

The blog summarizes information on MS Access database Embedded OLE objects don’t work properly issues. It also describes the method to retrieve access to data in case the application do not display embedded object in access forms and reports. Also it mentions reasons that causes this particular Access File Corruption and the alternate solution to securely recover data objects.

Practical Scenario:

I recently updated my computer to Windows 10 version 1703 and since then embedded objects in Access forms and reports do not display properly (cannot be seen). When Windows is downgraded to its previous version the problem disappears. The problem occurs with Access 2010, Access 2013 and Access 2016 (all 64bit).

Source:

https://social.technet.microsoft.com/Forums/office/en-US/692c933c-7aee-447b-ae97-d47fa00a3df8/in-access-embedded-ole-objects-dont-work-properly-with-windows-10-version-1703?forum=officeitpro

ISSUE

This particular issue is usually encountered when viewing the report or form that uses a Bound Object Frame control to display the value of an OLE object column in a table. This leads to the problem where the OLE objects are not displayed.

Other Related Issues Encountered Due To This :

  • Pictures not showing in printed versions of reports
  • Report image not showing
  • Control Source for Image not working
  • Access report not printing images
  • MS Access report not showing data

WORKAROUND

To fix this Access forms and reports do not display embedded object issue, try the following workaround.

This problem occurs due to change in the order of preference for formats used to cache the presentation of OLE Objects, along with an issue when using the Enhanced Metafile format.

You can make changes in behavior by explicitly specifying the order of format preference by trying the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager

Under this key, add a new Multi-String value, named OlePictureFormatPreferenceList, with the value data:

METAFILEPICT

ENHMETAFILE

BITMAP

DIB

 Images Not Showing In Access Forms And Report 

Issue:

Sometimes the problems also rendered that your added images on your forms and reports may appear blank in MS Access 2016.  Here is the screenshot of the form with a picture image that is blank in Access 2016.

Usually this problem is encountered with the 32-bit version of Access 2016 and not in the 64 bit version.

Not All Pictures are Invisible

Sometime the issue is also arises where some pictures are appearing properly and some are not. After the research, it is found that:

  1. Images that are originally BMP files appear properly.
  2. Images having GIF, JPG and PNG formats appear blank.

Resolution To Fix Access 2016 Report Image Not Showing issue:

If you are rendering with this access report not showing data then just follow down this complete manual fixes to resolve Access 2010/2013/2016 Image Not Showing error.

Impacted by the Picture Property Storage Format Setting

On further investigation, it is found that problem is mainly associated with the database’s Picture Property Storage Format when the pictures were added to the form or report. This comes under the Access Option setting for the Current Database.

Well there are two options that you can try:

  • Either Preserve source image format (smaller file size)
  • Or convert all your picture data to bitmaps (compatible with Access 2003 and earlier)

If the image is added when the second option is been selected then the non-BMP graphics do not appear in the Access 2016 version.

How To Include A Bound Picture In A Microsoft Access Report?

Well it is possible to actually store the images within the Microsoft Access database itself as OLE objects, though it is not the preferred way. When you embed an OLE object in the table, it means you are storing lot of overhead as well. This overhead is actually the information about the object which access application stores to render the objects properly.

In case of Images not showing in Access Forms and Report; the preferred way to display image is to store the complete path and filename of the actual file name themselves within the table and then use the image tool (in Access 97/2000) to update the display.

Here is the following example that will shows you how to display Windows bitmap images on MS Access report without storing the images in a Microsoft Access table.

ALSO READ:

How To Fix MS Access Run-time 3146 ODBC Call Failed Error?

Creating the Table to Store File and Path Data:

  1. Firstly you need to make a new table with name Imagetableand then add a Text Field with name ImagePath.
  2. Now Open the Imagetable table in Datasheet view. Then add the path and add name of a bitmap file to each of your record. The following example is to show how the records look like:

c:\windows\circles.bmp

c:\windows\waves.bmp

c:\windows\tiles.bmp

c:\windows\bubbles.bmp

Displaying Images in a Microsoft Access Report

  1. To create a new record you can also use the AutoReport Wizard which is based on the ImageTable table. Name the report ImageReport.
  2. Open ImageReport in Design view and then add an image control to the report by using the Image tool in the toolbox. You are prompted to select an image to insert. Select any image that is available on your computer. Name the control ImageFrame.
  3. Set the Format Event of the “Details” section of the report to the following Event Procedure:

4.    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)5.         Me![Imageframe].Picture = Me![Imagepath]End Sub

  1. Open the ImageReport in Print Preview mode. Notice that the report displays the corresponding bitmap for each record.

Note: You may need to amend the file paths and image names to correspond with images stored on your system.

Alternative Solution To Fix MS Access Report Not Showing Data:

Meanwhile, if you have lost your Access Database embedded OLE objects then also you have the chance to recover it back. this is possible with Access Database Repair is software that is particularly designed to repair corrupt or damaged MS Access database files. It comes with powerful algorithm that scans even severely corrupted access database files.

It easily restores damage or corrupt tables, queries, indexes and other data. This tool can easily fix all minor and major database errors and problems of MS Access 2013, 2010, 2007, 2003, 2002, 2000 on almost all version of Windows operating system such as Windows 8/7/Vista/XP/2003. Free trial version is available that you can install to check the features and reliability of the software.

Steps to Recover Corrupted or Damaged MS Access Database

Wrap Up:

After reading the complete post now you are well efficient to display image in Access Report. So, what are you waiting for just follow down the manual fixes and easily get rid of access report not showing data issue on your own.

But if you don’t want to take risk of trying manual fixes then just go with the software solution. As it is completely safe and you don’t need to be an expert for operating this.

How To Fix Access Forms And Reports Not Showing Image Issue