All right guys, help me out if you can. This is a movie about a guy who loves to party and drink, etc and then he dies. Instead of going straight to heaven or hell, he is in the middle and a voice is talking to him telling him he can go back to earth but it will have to be as a woman. He goes back and becomes a woman and eventually falls in love and has a kid, but dies as the kid is being born.

Please help!

Sounds like Blake Edward's "Switch" (1991) starring Ellen Barkin, Jimmy Smits, JoBeth Williams and Perry King

HBO Home Video UPC: 026359055027