Use button set up to format the field as a button. The script it performs when clicked can then open the image or change to a layout set up for displaying it in a container field.
Ps, I think you meant that your calculation was: GetValue ( img 1 ; 3 ) instead of getasText.
Thanks. Yea, I meant GetValue.
This solution seems great, but I'm having trouble getting it to open the file path specified in the field img 1 path. When I go with the Open URL option, i.e., it always adds the "imagewin:/" for the letter drive, and nothing happens. Is there a way to parse out the "imagewin:/" from the path?
If these images are stored on the C: drive, you could use this expression:
"C:" & Right ( Table::Filepath ; length ( Table::FilePath ) - Position ( Table::filePath ; ":" ) )
I actually achieved the same thing using this calculation:
Substitute ( GetValue ( img 1 ; 3 ) ; "imagewin:/" ; "" )