Image Control in Continuous Forms

[Guest]

Hi, I have been converting an Access 2003 application to display images from
files through an image control rather than embedding images in the database.
I have used the knowledgebase article here as a guide:
http://support.microsoft.com/default.aspx?scid=kb;en-us;285820
This works fine in single forms, however I have some continuous forms. I get
the same picture in every row of the continuous form, which I understand from
other posts is because the on_current event fires only once, so I can't use
it.
The question is, what can I use?

 

[John Nurick]

Hi Gareth,

As far as I know there's no way round this: the only way to get a continuous
form to display different values in different records is to bind the
controls to the form's recordset. If the images are small - and I can't
imagine anything much over thumbnail size being useful in a continuous
form - it won't do any harm to store them at screen resolution in an OLE
field in the table (with hi-resolution versions, if needed, maintained in
separate image files).

If they're larger, I'd put a single image control in the form header or
footer, and use the Current event procedure to display the image belonging
to the selected record. (Or maybe use 3 image controls and display the
images for the previous, current and next record. Or maybe use a continuous
subform in an unbound form, with the image controls on the form...)

 

[Guest]

John:

Thanks for the response. I think you're right, there is no easy answer from
other reading I've been doing.

The images I am displaying are thumbnails, although they are scaled down
from larger sizes on the form, so your first suggestion is one workround I
hadn't thought of - only issue being that I would have to resize all the
images and load them into the database rather than display them dynamically
from the file.

I might work on your second idea, maybe having 8 image controls on a single
form placed alongside the continuous form, although I suspect this will
involve quite a bit of coding!!

Thanks for your suggestions.

Regards