Get rid of anything in the cupboards you don't want him to eat. It means the rest of you don't get the sweets either, but maybe that is a good thing.
Then, maybe take him in for a physical and see if there is any medical reason for the night scavenging. If not, lots of people have had great...