I have this very simple table in Microsoft Access:
And this form:
The image next to each record changes based on the "Glasses" field automatically, so when "Glasses" is true, there is an image of glasses, and when it is false, there is an image of a person.
I have two images in my Image gallery: glasses.jpg and noglasses.jpg
And my image source is set to:
=IIf([Glasses],"glasses.jpg","noglasses.jpg")
As you can see this is all working great. The problem starts when I'm fully exiting then reopening my project in Microsoft Access: All of the images just disappear.
I was wondering if there is any way to fix that.
I did find a way to make them appear again but it require an action every time I open the database:
- By going to the form design
- clicking "insert image" (for some reason all of the images are there)
- right-clicking an image (does not matter which image)
- Clicking "Update"
- Selecting the image again from the files explorer
- Opening the form again
CodePudding user response:
Apparently, setting the image type to "shared" and changing the image source to:
=IIf([Glasses],"glasses","noglasses")
Solved the issue