Load images dynamically in Report

[apagan1959]

I have an Image Control in a report. The "Picture Type" is set to "Linked" and I've left the "Source Control" blank. I want to be able to set what image is displayed in the Image Control using VBA. I've made several attempts using the following:

Image.Property = "c:\images\image_name.jpg"

But, I am quite sure that is not the correct syntax or function. I've done some Googling, but have not found a solution. Would someone point me in the write direction, please.

Thanks, in advance.

[June7]

Is Image the name of the Image control? What event is the code in? Review http://www.databasedev.co.uk/bound_image_report.html

Why don't you use ControlSource property and not VBA? The VBA method will not work in ReportView, only PrintPreview or direct to printer.

[davegri]

This report works for me. The control on the report is an Image object. In my case the path is in the recordsource for the report.


Format properties:

[apagan1959]

No the acctual control name is "HoFImage". The reason I want to use VBA is because the image is only displayed for rows that meet the WHERE criteria. Therefore, I have an IF statement in my VBA that looks to see if the WHERE criteria has been met, if so, the image is displayed (if not, the image is not displayed). So, what I am trying to do is get the appropriate VBA code to assigned the image to the Control only when the image is to be presented.

Thanks.

[davegri]

June7 requested information, and I'll try likewise:
What's the RecordSource for the report? Is the image path in the RecordSource? Where is the VBA "WHERE" criteria? What VBA code have you tried, and what event is it in?
One technique that I have used is if there is no image file, display an image that has the text "No Image Available", in which case an image is always available.

[Gicu]

Image.Property = "c:\images\image_name.jpg"

You use the .Picture property not the "property" property, so it would be HoFImage.Picture="c:\images\image_name.jpg"

Cheers,
Vlad

[apagan1959]

Thanks to all the responses that I've recieved, I've figured it out! I am now able to display an image on a report based on the value of a query (now, an if statement). Here is what I am doing. I am using an IMAGE control and Control Source I am using an If Statement that compares a TempVar, which gets its value from a field in a table.

Here is the actual statement I am using in the Control Source
=IIf([TempVars]![HoF]="Y","C:\image\HoF.jpg")

I set the HoF TempVars when the user clicks on submit (using VBA). I do a DLookup that sets its value.

TempVars!HoF = DLookup("[column]", "[Table]", "[table].[column]=Y")

Sounds convoluted, but it is working. Thanks all!