Limitations Displaying Graphics on Continuous Forms

[Cavman]

Hi,

Here's what I'm trying to achieve:
I have a continuous form that displays a list of records. I need to display a logo next to each record that relates to that record. The path to the logo is stored in the table and currently I'm using 'Me.imgProjectIcon.Picture = Me.ProjectLogoPath.Text' in the code to pull the correct graphic in and display it.
Obviously, as Access only has one set of controls for all records on the continuous form, the last referenced graphic is the one displayed for all records, which is no good!
Does anyone know a way I could get around this? I wondered maybe if anyone has created their own code to mimic the continous form in displaying cascaded records pulled from a table rather than using a continuous form?

Any ideas would be appreciated.

Thanks,

Simon

 

[Simon_MT]

If you using Access 2007+ then the Imagecontrol Control Source Property should be:
="ProjectLogoPath"

Assuming that you referentially accessing images and the ProjectlogoPath is dynamic.

Simon

 

[Cavman]

Hi,

Thanks for your reply. I finally figured out how to do what I wanted by entering the world of OLE objects! I've managed to get it to do exactly what I wanted - just a shame that the formatting controls are a bit limited - the images all come in left and top aligned rather than centred, but I can get around that by making sure every graphic is the correct size.

Thanks again,

Simon

 

[Simon_MT]

Hi Simon,

An Image control can be centred I never use Objects as Large as Elephants.

Simon

 

[Cavman]

I'll remember that, thanks! Fortunately the graphics are all tiny and there's not too many of them, so I'm ok for size at the moment