Displaying image in calculated field

[ceci123]

hi.

My first time here.

I am trying to display an image1 and image2 which is stored as an 'OLE Object' data type. I also have other two fields: value1 and value2 both are 'Number' data type.

I am trying to do this on my calculated field:

Result: IIf([value1]<=[value2],[image1],[image2])



When I run this it shows me some weird characters something like [?]$[?]

Do you guys know how I can achieve this?

Thank you.

[maximus]

assuming that u have to display only two pictures depending on the values of two fields Value1 and Value2 I have done the following:

1) I have Created a table that will hold the pictures in a OLE Field.
Tablename:tblpic
Fields: PICID(Autonumber PK), PIC(OLE)
2) I have a another table with the Following Fields
Tablename: valueTable
Fields: ID(Autonumber PK), Value1(Number), Value2 (Number)

I build a form with table valueTable and put a Bound Object Frame with the Following expression in its Control Source

=IIf([value1]<=[value2],DLookUp("[PIC]","tblpic","[PICID]=1"),DLookUp("[PIC]","tblpic","[PICID]=2"))


Now this expression ensures that Picture with ID 1 is displayed when [Value1]<=[Value2] otherwise Picture 2 will be displayed.

I have put this code in the on current even of the form:
Me.OLEBound3.Requery

This re queries the Object Frame when u navigate through the form displaying the correct picture.

[ceci123]

Thank you for your answer. I've tried your trick and it works... but its not web compatible.

When I tried to deploy it I get a "ACCWeb107000... OLE Object type is incompatible with web" something along those lines. The other data types are
http://office.microsoft.com/en-us/ac...#_Toc254722314 but not sure if I can use this to store an image.

Thank you for your help.

C