Image on a continuous form that changes pr record

[whitechair]

I have two images on a record on the detail section of a continuous form. I would like to have one image visible when textbox1 is greater than textbox2 and another showing when it is not. I would like this to depend on the record, so one record in the form may show this image and the next record would show the other depending on the values of the textboxes. Is there a way to do this?

[June7]

Don't know any way to do this on a continuous form, a report yes, form no.

You could use Conditional Formatting to set colors of textbox depending on the criteria.

[whitechair]

I heard about someone who set up a link to the images on a network and then had an image control look up the link. But I don't really want to worry about people having access to the correct path or naming their drives differently. Any other suggestions?

[June7]

Sorry, that is one possibility.
I just tried using UNC referencing for file path and that worked
UNC (universal naming convention) syntax is: "\\servername\path\filename"

Could also try this:
A table with a single record and two attachment fields, one for each image (Image1, Image2). Include this table in form RecordSource without a JOIN clause, this will cause the Image record to associate with every record in the parent table. Conditional statement in Image control ControlSource property:
=IIf(textbox1>textbox2, [Image1], [Image2])
Not tested, just a brainstorm, let me know if it works.