image in reports

[samjesse]

Hi

Please help with my request. Thank you in advance.
I have a report which gets it's records from a table which has OLE Object data type being a "file.jpg".
How can I get the image to show in the report print view and also print it with the report?

Thanks alot

 

[rzw0wr]

I am not sure in other versions. In 2010.
If the report is bound to a query the add the object to the query and select it like any other field.

Dale

 

[samjesse]

I am not sure in other versions. In 2010.
If the report is bound to a query the add the object to the query and select it like any other field.

Dale

As I am working with Access 2000.
The control in the report view shows the text which is file.jpg and not the actual image.

 

[rzw0wr]

Are you saying that when the report is opened in report view, that the control that should show the .jpg image says "file.jpg"?

Interesting.
What image name does it show in design view?

Dale

 

[samjesse]

Are you saying that when the report is opened in report view, that the control that should show the .jpg image says "file.jpg"?

Interesting.
What image name does it show in design view?

Dale

Yes. where 'file' is the name of the image file.
In design view, the name is Image which is the name of the field I choose in the underlying table.

 

[rzw0wr]

Just image?
The object should have a name?
What is the name in the table?

Dale

 

[samjesse]

It works with .bmp but not with .jpg