Display image from attachment field

[ZachAtaiyan]

Re: https://www.accessforums.net/reports...eld-30861.html

Would there be an expression that can be added to the attachment field that would require it to display the 2nd attachment instead of the first?

[burrina]

Why not simply use the attachment arrows?

[June7]

Certainly can't put expression in attachment field. Can't selectively display specific item of attachment field. Would probably have to extract the image to external location and then reference that image filepath\name in ControlSource.

If you want to display a specific single image, then should be only one image in field and either multiple fields or multiple records for images. Or store images external from db.

[ZachAtaiyan]

Certainly can't put expression in attachment field. Can't selectively display specific item of attachment field. Would probably have to extract the image to external location and then reference that image filepath\name in ControlSource.

If you want to display a specific single image, then should be only one image in field and either multiple fields or multiple records for images. Or store images external from db.

So simply put, what I would like to do (have three of, say AttachmentField1, shown on a report displaying 3 different pictures attached within that field) cannot be done?

@burrina: I would but we will have around 1000 records when this is all said and done. I would prefer to avoid having to go through the pop-up arrows for each record on the report and select the one I want displayed.

Sorry if I seem dull, but is there ANY way that this can be done? Even any cutting edge ideas?

Thanks!

[ItsMe]

I have seen VBA code somewhere for the attachment "Control". I think I helped someone before with VBA to manage the properties/methods from behind a form. Not sure how this translates to a report rendering to Print Preview.