Under what condition does a convex lens nearly act as a diverging lens?

When a convex lens is placed in a medium with a higher refractive index than the lens material (e.g., in water), it can behave as a diverging lens instead of a converging one.