Attachment Images displaying Sideways

[Scalec]

Hello!



When I am in the table for my form, I can click on the attachments for each record and they will display right side up. But when I go into the form, they are always displayed rotated to the left ninety degrees. I have manipulated the photos in the record to be rotated other ways, but the form images remain the same. Does anyone know a solution to this problem?

[June7]

Can you provide the db or at least one of the photos for analysis and testing?

[leggs972]

Experiencing the same problem in Access 2010 64 bit. Created a form to display uploads from my cellphone, database tracking trucking load / delivery / unfortunate incident info, etc... Anyway, my Galaxy S6 takes images of 5321 x 2988 pixels; 16:9 ratio. That setting can be changed, but all the image options are relatively large. That particular image size translates into a 'print' size of 41.5" x 43.778". Kinda big, right?! I can upload the image in the form and it will display sideways. When I open the attachment, through the form, to manipulate it using Windows Photo Gallery, it opens oriented correctly as you've noted. If I then rotate it sideways and close the dialog it self saves, still displays incorrectly in the form. But, if I then re-open the attachment dialog and re-rotate the image to it's proper orientation, when the dialog closes the image will once again self save and display correctly in the form. Odd, at least to me. It seems that image size is somehow the issue. If I take an original image from my phone and shrink it to say 2" x 3", and then save it as an attachment, it displays correctly oriented in the form every time. This is a time waster! I'm a super novice db app creator, now searching for a way to programmatically convert the original images to a suitable size as they are uploaded into the db as an attachment. I've searched the vba object browser but don't see anything obviously useful. Looking for some magic guys.

[June7]

So need VBA to open the image in some application object, like VBA opening an Excel object and manipulating worksheets. Unfortunately, as leggs972 notes, there does not seem to be any object library for this functionality. Not even for MS Picture Manager or MS Paint, neither of which is packaged with VBA. And Picture Manager is not supported in Office2013 and later.

The only image manipulator library I can see is for Adobe Acrobat.

[leggs972]

Score! Haven't tried it yet, but sounds perfect https://www.devhut.net/2017/01/23/vba-manipulate-images-resize-convert-and-more/