I am using 'GetAsText' to place the path and filename into a field and I would like to then use the file suffix .jpg .mov .pdf .doc or docx etc to switch to an appropriate layout. All documents and image files are stored by reference only.
The paths and filenames are all rather long but the last 3 or 4 characters are always the file suffix.
This is a project for my local history society that I had to set aside for a while. Previously I had lots of help from the community and I'm now trying to 'fine tune' my FM app.
Thanks in advance