Show/ hide image based on some field value

[capitala]

Good Day,
in my report, I have two unbound images. I wish to show only one of them based on some field value. i.e. if the completion percentage exceeds 50% then the first image is visible and the second is invisible. and if it's less than 50% the first image is invisible and the second is visible.
how to do that?

Thanks

[amrut]

Set both the images' visibility to "No"
In the report's open event use the following code -

If [completion percentage control name] >50 then
     Me!Image1.visible =true
Else
    Me!Image2.visible =true
Endif

[capitala]

Actually I've tried this but it will be visible or invisible for all records not only for the relevant record.

[orange]

see this link for possible solution
http://office.microsoft.com/en-ca/ac...010208133.aspx

[June7]

Conditional Formatting not available for Image or OLE Object controls.

Luckily, you are using Access 2007 which introduced the ControlSource property to Image control.

If the report is displaying continuous records (as opposed to filtering to one record) then suggest options:

1. A table that has the two images embedded in two attachment fields. If the report RecordSource is an SQL statement, save that SQL as an Access query object. Then make the report RecordSource a query that joins the table to the saved query without join clause and this one record will join to every record of the primary data source. Then an IIf expression in ControlSource property of Image control to select the desired field.

or

2. Images saved externally and also an IIf expression in ControlSource property of Image control to selected the desired image.

RATS! I can get 2 working but not 1.