He will progress, I do understand the concept of functioning addict, but it only lasts for so long, the party always ends, especially if he's snorting it.
But personally what I would focus on more is the fact that it makes you unconformable, that's the only thing you have control over.