Export Field contents will open the file, provided that the file (or a reference to it) is inserted into a container field.
It should not produce a "snippet of text" unless it is exporting from a field of the wrong type.
What you describe is typical for exporting from a text field or a calculation field with text specified as the result type.
And you would not need the above calculation in order to do so. The file path to specify should be the location to which you export the file, not the location where the file is currently located.
PhilModJunk Thanks for the reply. Have checked and the calculation is definitely set to produce a container, not text.
Have gone round in circles for the last hours. A file is being created in the temporary path, with the image file's name but it isnt the image file.... I have posted a cut down test version of the database with images on my dropbox & would be very grateful for any further guidance.
Your solution appears locked with a password auto-entered via File Options. I'd need to be able to open it with a full access password.
try user Admin
You are exporting from the wrong field. Change Export Field Contents to export from your calculation field, Photo_1, instead of Photo_to and this will work.
The attached image shows why I needed a password to open the file.
Many thanks, and sincere apologies for wasting your time with my error.
We've all been there. Sometimes we just can't see the obvious mistake because our brain fills in what we expect to see instead of what is actually there.