Best method of bound images?

[agehoops]

For records that have an image (such as members of staff having a picture for each one) what is the best method for displaying this picture on the form?

Currently I've got an image box which is updated with the file location reference stored in the table. it work well, however, in order for the image box to be on the form it has to have a default image which may not be on every computer it is run on. Is there either a way of getting rid of this default image, or a different /better way of doing the images.

Thanks

 

[Oldsoftboss]

If the default image is actually on the PC you can remove it. If you copy the Db to another computer that does not have that file, if you try to remove it, a message will say that it cannot be found and wont let you remove it. Well deeerrrrr.... Access Ha

 

[agehoops]

Ah wow. I swear when I did that first it just deleted the image box with it

Thanks

 

[wiklendt]

you don't delete the image control, you should delete the property "Picture" in the format tab to say "(none)" (which you can do by deleting the reference). you are then left with an empty image control which you can use to place any image in there via VBA.