I am seeking help to display images on forms and reports. I am on Windows 10, using Access for Office 365 MSO 64-bit.
I am using the method of displaying images with a "short text" type data consisting of the full path and filename of an image file, coupled with an image control set to that record source. It works fine on most images, but on a few, it simply doesn't display the image.
I have compared all the attributes of different image files (that is, all attributes which can be shown in a column in the File Manager window), and I can't discern any different specs which would prevent these certain images from not displaying. They are all JPG or PNG, small files, saved for web use, 120X120 or smaller, nothing out of the ordinary, but there are a lot of them for my world ( probably 10,000 images spread across six different fields in 3,000 records).
That method of displaying images was recommended to me as the "only sensible " way to display images. I am a novice with Access, but did some database programming with Paradox years ago, but I admit I don't know what "sensible" is.
I see there is another way to display images: to set up "attachment" type fields and then attach images to that field of each record through a dialogue box routine. I can try this method, modify my table, add the attachment fields and run through the dialogue box process for perhaps three and a half fields in 3,000 records. That seems like it will require about 10,000 individual modifications to my data.