Setting the "picture" property of an image control

[GraeagleBill]

On a continuous form, where each record in the RecordSource contains the file name of a jpeg image, what event or method allows me to set the picture property of an image control. Each record contains the description of an item and its picture is also to be displayed on the form.

I need the equivalent of the "On Format" event (I guess) in reports where I can set the file and path of an image in the picture property.



Thanks,
Bill
(PS) Can't believe I've not encountered this before on a form...............first time for everything even with old guys.

[June7]

Don't know if Access 2003 can handle that. http://ms-access.questionsfind.com/q...se_104654.html

See if this helps http://office.microsoft.com/en-us/ac...001147204.aspx

Scroll down to the section "Display bound images (images that change with each database record or report page)"

[amrut]

Add an Image to your bound form. Set it's picture property to "Linked" and set it's control source (on Data Tab) to the field storing path to the picture. This works for Access 2010.

[June7]

amrut, Image control in 2003 doesn't have ControlSource property.

[amrut]

Never used Access 2003, thanks for the info.

[GraeagleBill]

The key issue here is "Continuous Forms". The descriptions offered in the Microsoft link doesn't address setting links in record controls for continuous forms. One could do that with bound OLE controls and use bmp file formats, but that was not a viable method in this case. The app is of very limited use and doesn't justify any further efforts, so I'll mark this resolved and move forward with single record form approach. Thanks for your thoughts and efforts.
Bill

[June7]

That's why Access 2007 enhanced the Image control with a ControlSource property.

[GraeagleBill]

One of these days, I'll convert all the many right-click pop-up user options I have to ribbons so I can move off of A2003.