OLEs not showing up in forms & reports

MCRetro

New member
Local time
Yesterday, 23:54
Joined
Sep 4, 2014
Messages
3
I am using Access 2010.

I have a database with two OLE fields in the table.

Most of the images stores in the OLE fields show up in my form and report.
The ones that do not show up in the form have the name of the file (ex. 1234.bmp) with the icon for MS Paint (the painter's pallete) with the
words "command line".

The ones that show up in the form look exactly correct.

In the report, the ones that do not show up in the form are just a white blank square.

Also in the report, the ones that show up in the form, show up correctly in the report.

All the graphics are BMP, have the same dimensions, are all 24 bit, etc.

All the graphics are linked to graphics in another table.

When I go to the table in my database, I can click on the field, and all the graphics show up in my graphics program (even the ones that do not show up in the form or report).

The Access database is about 66 MB.

What can I do to get all the graphics to show correctly on the screen for the form and the report?
 
Welcome to the Forum! :)

Hmm, going to say since most don't store images within the database it explains the lack of replies...

You really don't want to store pictures in the database, it will cause bloating which will push your database to it's max size (2 gig) very quickly. Try this link which has MANY samples of how to insert/display images in forms and reports.
http://www.granite.ab.ca/access/imagehandling.htm
 

Users who are viewing this thread

Back
Top Bottom