Displaying Images in REPORT

  • Thread starter Thread starter Kevin B.
  • Start date Start date
K

Kevin B.

Hello,

Can anyone tell me how to display an image correctly in a report? I am using
it as a part list for customers.

EXAMPLE: COLUMN 1 shows PART # , COLUMN 2 shows DESCRIPTION, COLUMN 3
shows IMAGE.

The information from this report is pulled from a table. I loaded a .bmp
image in the table field which is the only type of image file that I could
get to display. the field type is set to OLE object.

The image displays but the quality is terrible. It has a black background
and there is text below which displays the file name which takes up space.

Any ideas?

Kevin B.
 
MS Knowlege Base article 148163

Displaying Images in a Report
1. You can use the AutoReport Wizard to create a new report that is based on
the ImageTable table. Name the report ImageReport.
2. Open ImageReport in Design view and then add an image control to the
report by using the Image tool in the toolbox. You are prompted to select an
image to insert. Select any image that is available on your computer. Name
the control ImageFrame.
3. Set the Format Event of the "Details" section of the report to the
following Event Procedure:
4.
5. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
6. Me![Imageframe].picture = me![Imagepath]
7. End Sub

8. Open the ImageReport in Print Preview mode. Notice that the report
displays the corresponding bitmap for each record.
 
Back
Top