How can i Display bitmap image on ms access Report?

  • Thread starter Thread starter Ragueh
  • Start date Start date
R

Ragueh

Hello Everyone;
I am trying to display images in ms access reports.Some images are displayed
and a lot of them are not .When no picture is dispayed i get an ms access
report error message number 2114,Which tells me that the format is not
supported or the file is too big, and suggests me to changes the file format
into BMP or GIF.When i took a look at those pictures which were not been
dispayed i found out that they have smaller size the one been displayed.I
googled around in search of a solution to this problem, but only came up
with solutions that have nothing to do with my issue.Can anyone , please
help.Thanks in advance.
 
Ragueh said:
I am trying to display images in ms access reports.
Some images are displayed and a lot of them are not.
When no picture is dispayed i get an ms access
report error message number 2114,Which tells me
that the format is not supported or the file is too
big, and suggests me to changes the file format
into BMP or GIF.When i took a look at those pictures
which were not been dispayed i found out that they
have smaller size the one been displayed. I googled
around in search of a solution to this problem, but
only came up with solutions that have nothing to do
with my issue.
Click to expand...

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP
 
Back
Top