Change picture property of image control

[GraeagleBill]

I don't see where to set the picture property on an image control as the Detail section is formatted. On a continuous form, the detail section includes a thumbnail image. The name of the image that is to be used as the picture property is included in each record. I can set a default image in the picture property in design mode, but I don't see where to override the image name as the form opens. There's no OnFormat for the Detail section and trying to use the OnPaint just seems to put Access in some sort of strange loop if I try to set the Picture property there.

I could change the ControlSource for the control, but again, without a format event I don't see where?

[June7]

There certainly is Format event for Detail section.

However, use ControlSource property and Format event code is not needed. Using Picture property and VBA was necessary back with Access 2003 before ControlSource property was added to Image control.

Are these external image files, not embedded in table? Simply set ControlSource to an expression that includes the image file path. If this is a split db with backend on server, advise use the server name, not a drive letter mapping.

Example:

="\\servername\folderpath\" & [fieldname] & ".jpg"

[GraeagleBill]

There certainly is Format event for Detail section.

Exactly what I expected but the event does not show up in the list of events for that section. So, I set the ControlSource of the image control in design mode to

"c:\PictureBoxes\PicImages\" & [PicName]

Where PicName is an expression of the form "name.jpg" or "name.png" and is included in the control source query for the form.

Access says the expression I used is invalid.................... edit Oops! forgot the "=" ALL GOOD NOW

[June7]

Not showing = sign.

Your PictureBoxes folder is located at C: root, not in a Users folder?

Sorry, I was thinking of report for Detail Format event. Correct, forms do not have Format event (don't see Paint either). On form would probably use Current event to dynamically set Picture property. However, no form event would work nice for Continuous form.

[pbaldy]

There certainly is Format event for Detail section.

On a form? Not in my experience.

Off to the air races!

[June7]

On a form? Not in my experience.

See post 4.

[GraeagleBill]

Your PictureBoxes folder is located at C: root, not in a Users folder?

Just something temporary for my own use.