Problem with displaying images in ms access

[calobo]

Hello

I'm not very experienced in ms access and I'm trying to make a data base where specefic images appear on a form and a report.

Searching the net, I came across a way to do this, in which the image is placed on a folder on the hard drive and the images are linked to apear in the corresponding form in ms access.

I created a text field in the table where you want to store
the picture, and put the path to the picture there. Then on your form, I
created an Image object, and in Form_Current() wrote:
Me![ImageFrame].Picture = Me![fImagePath]

This works quite well, but I have a problem which is quite bothering.

Not all records have a image address liked, so no image is supposed to appear in records that have no image address.
The problem is that when I moving across the records in the data base, if I go from a a record that has an image to one that is not supposed to have an image, the image of the record that has an image appears on the image box of the record that is not supposed to have an image in the image box.
I would think that if a record does not have an image address, the data base would show a blank image box, but no, he appears to keep the previous image untill a new address gives him new information.

I want a record to display an image if it has an image address and those that do not have an image address, the image box appear empty

Can anyone help me to resolve this

Best wishes

Carlos

[hertfordkc]

Where you put the command depends on how you are changing the records and how they are being displayed. Perhaps in a control on the form which changes when the record changes.