>>Suppose you want to link pictures (JPEG) in your table so they can be displayed on forms and reports. Should the field type be character with the filespec for the photo, or general with a link to photo? Assuming the answer is General, how do you set the form image control and the report image control to display the picture?
>>
>>
>>Thanks
>
>Your field should be either Character (file name) or Blob (actual image file contents). On form use Image.PictureVal=[blob field]. On report use Picture/OleBound bound to file name.

Thanks Ed

I had this set up and working with a character field containing the file name. It worked fine on the form but I couldn't get it to work on the report because the image control needs to be linked to the field and not hard coded to a specific file. I would prefer to not imbed the picture directly into the table to avoid blowing up the file size. Can you provide a better clue on how to set up the report control?