Picture Problems

  • Thread starter Thread starter Paul Hammond
  • Start date Start date
P

Paul Hammond

I have a column in a table linked to a series of
bitmaps. These show up as a package, no problem.
Double click on them and I can view the pictures, no
problem. When I try to show these pictures on either a
report it should up either garbled, a small black square
or a very low res version of the original. I have had
to resolt to using an image control that is refreshed
using visual basic. This works, but seems unnecessarily
complicated.

Any ideas?

Paul Hammond
Richmond, VA
 
I have a column in a table linked to a series of
bitmaps. These show up as a package, no problem.
Double click on them and I can view the pictures, no
problem. When I try to show these pictures on either a
report it should up either garbled, a small black square
or a very low res version of the original. I have had
to resolt to using an image control that is refreshed
using visual basic. This works, but seems unnecessarily
complicated.
Click to expand...

When you use bound or unbound OLE Frames to display images, you are at the
mercy of the software the user has registered for the file type you are
displaying and its interaction via automation with Access. I primarily avoid
storing images as OLE objects because of database bloat, but also for
reasons similar to those you describe.

I find the Image control, either with external files or with images stored
in BLOBs, not to be particularly complicated, and it seems to be much more
predictable than OLE.

Three methods of handling images in Access forms are included in examples
you can download from http://accdevel.tripod.com.

MVP Stephen Lebans has additional information, examples, and even an image
control of his own (free) at his site, http://www.lebans.com.

Best of luck with your application.

Larry Linson
Microsoft Access MVP
 
Back
Top