You can add a zoom effect on an image field with this module. Read first the instructions...
The files need to be in the correct folders.. You have to create the folders yourself.
Now you can configurate the zoom effect.
There are 4 possible triggers. Try them out.
Here i use mouse over on this picture..
This is the 'normal' display. Always choose a smaller display then the original...You can not zoom on the original..