# Access 2000 Forms: Inserting an image?
**URL:** https://boards.straightdope.com/t/access-2000-forms-inserting-an-image/214158
**Category:** Factual Questions
**Created:** [November 19, 2003, 6:58pm UTC](https://boards.straightdope.com/t/access-2000-forms-inserting-an-image/214158 "2003-11-19T18:58:49Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@NoGoodNamesLeft](https://boards.straightdope.com/u/NoGoodNamesLeft)
#### Post date: [November 19, 2003, 6:58pm UTC](https://boards.straightdope.com/t/access-2000-forms-inserting-an-image/214158/1 "2003-11-19T18:58:49Z")
AAAARGGGGHHHHH!
Ok, now that’s out of my system…
Here’s my problem. I have a database that keeps track of club members. That database has a good form for entering the dat, and making changes.
However, I want to display a picture of the member with their profiel when I bring up the form (or a report fo that matter).
The image has to be that of the individual member, and change as I scroll through the memebrs in the db.
What I did was add a column to my table, and put links to my pictures in it. But when I try to show the omage in the form,
it gives me an icon instead. When I click the icon, it will open the picture in a new window.
The icons and their links all point to the right place, but I want to actually display that image there.
I checked the properties and it’s not checked under “display as icon”, and I made sure that was off when I added the data field to the form.
Can anyone PLEASE help?
---
### Author:  [@Starbury](https://boards.straightdope.com/u/Starbury)
#### Post date: [November 19, 2003, 7:24pm UTC](https://boards.straightdope.com/t/access-2000-forms-inserting-an-image/214158/2 "2003-11-19T19:24:00Z")
Here are the possible solutions I was able to find:
> [@](#):
>
> There is a connection somewhere between Access and MS Windows Paint program.
> The very first image I inserted into my OLE field was a JPG image. Since MS
> Paint can’t understand JPGs, and since Access is somehow setup to use MS Paint
> as a default image viewer, Access got confused and instead inserted a “Package
> Object”. I was able to view the Package Object as an icon, and could
> double-click to view it in my default image viewer but the image would not
> display in anything but an icon in my form. All settings in Access that
> control whether an image is viewed as an icon or as a full image would not
> work, since technically this was a “Package Object” and not an image…at least
> as far as Access was concerned. (Normally in table view, when you insert a
> bitmap for example…the field value will say “Bitmap Object” or
> whatever…mine always said “Object”). Arrgh!
>
> The work around is to insert an object, choose New when prompted (instead of
> existing) and select Microsoft Photo Editor 3.0 from the list. Once Photo
> Editor opens, choose a file with the standard file open procedure and then
> select Exit to Table from the File dropdown menu. The OLE object in the record
> will now be a Bitmap or JPEG or whatever instead of an Object. I haven’t tried
> it, but I think you could probably open any image viewer or graphics
> application instead of Microsoft Photo Editor with similar results.
Or it could be that Access doesn’t have all of the proper graphic filters installed. See online help via the index for ‘graphic filters’ for an explanation
At the bottom of this help screen is a double arrow link to show you how to run setup to intall them.
---
### Author:  [@jbird3000](https://boards.straightdope.com/u/jbird3000)
#### Post date: [November 19, 2003, 8:15pm UTC](https://boards.straightdope.com/t/access-2000-forms-inserting-an-image/214158/3 "2003-11-19T20:15:31Z")
To extent what **Starbury** said…
Try putting an unbound image on the form of one of the images you want to display. If it shows up fine, then you can set the source or whatever property of the image object to the path of image from the database in the Current event.
---
### Author:  [@BF](https://boards.straightdope.com/u/BF)
#### Post date: [November 19, 2003, 11:48pm UTC](https://boards.straightdope.com/t/access-2000-forms-inserting-an-image/214158/4 "2003-11-19T23:48:04Z")
If you go into the Northwind sample database, there is an employee’s form with pictures of the employees on each record. See what you can find there. From my own experience, I stick to .bmp’s and jpegs.
---
### Author:  [@NoGoodNamesLeft](https://boards.straightdope.com/u/NoGoodNamesLeft)
#### Post date: [November 20, 2003, 12:09pm UTC](https://boards.straightdope.com/t/access-2000-forms-inserting-an-image/214158/5 "2003-11-20T12:09:20Z")
Thanks, all… **Starbury** ’s work around did it.