Displaying images in Access Forms

[jeh]

Tbl.Main in my Access DB has 20 or so fields per record. One of the
fields is a hyperlink to a jpg file containing an image of the item
concerned. For those items for which no image is available the field
is blank. Images of dfferent items vary quite widely in size.

I want to be able to display the image in Frm.Main when the relevant
item is selected. How I should go about this? Is it possible to do
so without using VBA? Most of the info available via Google seems
quite old and far from clear. So far the best I've found (but haven't
tested) is at http://www.tek-tips.com/faqs.cfm?fid=1294, but it's also
quite old.

Currently the DB is in Access 2003 but I have Access 2007 installed,
on a Win 7 desktop PC. In the absence of another solution I'd accept
displaying the file's icon from Windows Explorer.

Any ideas anyone?

TIA John

 

[jeh]

I you are using Access 2007, you will find the Image control has a Control
Source property. Set this property to the full path of the jpg file, e.g.:
    C:\SomeFolder\SomeFile.jpg
and it will display the image, even in a continuous form.

Thanks Allen. I'll not get to this before the weekend. Meanwhile,
you say "Full path". All my image links are Relative path, to enable
the whole system to be ported between computers. Is this permissible
in the Control Source Property? If it isn't I'll need to find some
other way round the problem.

John