Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 258644 - Last Review: May 13, 2005 - Revision: 4.0
A linked JPEG file is displayed as an icon on a form
This article was previously published under Q258644
Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
A JPEG file that you are linking is displayed as an icon when you view it in an OLE Object field on a form.
CAUSE
By default, the interpreter for the OLE Object field is Microsoft Paint. Paint uses .bmp files, and when you try to store or link a JPEG file, the file is stored as
Package or
Bitmap Image in the table. The OLE Object field then uses the default header information and associates
Package or
Bitmap Image with Paint. This results in the JPEG file being displayed as an icon on the form.
RESOLUTION
To resolve this problem, use one of the following methods:
Method 1:
Use a different interpreter, such as Microsoft Photo Editor, to insert the object
- Open the Employees table in Datasheet view.
- Right-click the OLE Object field, and then click Insert Object.
- In the Insert Object box, click Create New.
- Under Object Type, click Microsoft Photo Editor 3.0 Photo, and then click OK. Microsoft Photo Editor opens.
- In Photo Editor, in the New dialog box, click Open an Existing Picture, and then browse to the JPEG file that you want to insert.
- Click the JPEG file. The picture opens in Photo Editor.
- On the File menu, click Exit and Return to tablename : Table.
Note that the value, Microsoft Photo Editor 3.0 Photo, appears in the OLE Object field instead of Package or Bitmap Image.
When you insert a JPEG file at the form level, you must follow these same steps again if you are using an OLE Object field on the form. Remember to size the OLE Object field to the correct size for your JPEG file.
Method 2: Display the images from a folder
Instead of storing the images inside the table as OLE objects, store the image file paths and the image names in the table and then display the images by using an image control. When you use an image control inside a form or a report, Access does not require the OLE Server to display the images in the image control.
For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
148463Â
(http://kbalertz.com/Feedback.aspx?kbNumber=148463/
)
How to display images in a form or in a report without storing the images in a table
285820Â
(http://kbalertz.com/Feedback.aspx?kbNumber=285820/
)
How to display images from a folder in a form, a report, or a data access page
210100Â
(http://kbalertz.com/Feedback.aspx?kbNumber=210100/
)
How to display an image from a folder in a form or in a report in Access 2000
MORE INFORMATION
Steps to reproduce the behavior
- Create a form that is bound to a table. Make sure the table has at least one OLE Object field.
- In Form view, right-click the OLE Object field, and then click Insert Object.
- In the Insert Object dialog box, click Create from File, and then click Browse to locate the JPEG (.jpg) file that you want to insert.
- Click the JPEG file, and then click Open.
- Click to clear the Display as Icon check box, and then click OK.
Note The JPEG file is displayed as an icon instead of as its actual image. Also note that if you look at the OLE Object field at the table level, you see Package or Bitmap Image as the value in the table field.
APPLIES TO
- Microsoft Access 97 Standard Edition
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please