Fish.movie — Big

It sounds like you're referring to the 2003 film directed by Tim Burton.