Michael Caine only realised how attractive his legs were when he pulled on a pair of tights and heels for his latest comedy role.