It's alright spud, feel free to go on about it as much as you need. It's a stressful situation for sure, and I agree with the others that if he cannot adhere to a request that should be simple for most people, then there are some underlying issues there.
Personally if it were me I'd be a jerk about it. My DH had some drinking issues before our first was due, he was military then and dragging me to house parties every night, playing drinking games and such, I put my foot down and told him to stop drinking by 37 weeks. Well he didn't, so the night I went into labor I told him he better stop drinking now or he was not going to drive me to the hospital, because I didn't want to ride in the car with someone who was under the influence, and if he had had even a little bit, not only would I find someone else to drive me, but he would not be allowed in the room as I was giving birth to our DD, and I would tell the nurses to not let him round until we were ready to leave the hospital. Sounds cruel, but I certainly was not going to put up with a husband who drinks excessively, especially now that we had children. And if he didn't stop, he needed to seek help immediately, or go cold turkey, or I would take our daughter and leave him without a second thought. Seemed to work, because he hasn't had more than 2 or 3 drinks in a night since on the days he decides to have a drink, which is pretty rare these days.