hi,
I have little knowledge in access and eager to know more.I have made a form named stcok details. It contains the follwing fields 1.part number 2.Image. I want to use iif condition in the image field expression. i want to load the material image when i give the part number. i have given following expression in image field, but it is not working.
expr1:iif([part number]="123","c:\images\mat.jpg","no image"). it give the words as it is inside the quote. how do i load the image. What is the data type of image field (text or OLE object)
thanks in advance
suresh