Somewhere between seven and ten, most children start asking. A classmate has said something, the handwriting on the labels looks familiar, or they have simply done the sums on chimneys. How you answer matters, and there is a middle path between lying and the whole truth.
Answer the question they asked
"Is Santa real?" often means "Is it all right for me to keep believing?" Ask what they think. Many children, given the chance, will tell you they still want to believe and would like you to keep it going. Do.
Keep the magic external
A child who is wondering is reassured by evidence that does not come from you. A letter with a North Pole postmark. The tracker showing the sleigh over Africa. A phone call where Santa says their name, mentions the thing they did well this year, and listens to their answer. Children who have had Santa ring them and ask them to set an example for the little ones usually decide that the question can wait another year.
When they are ready
When a child really has worked it out, make them part of it rather than ending it. Tell them the truth about who fills the stockings, and in the same breath tell them that they are now one of Santa's helpers, with a job: keeping the magic going for their younger brothers and sisters and cousins. Being trusted with the secret is a promotion. Most children take it very seriously.
The little ones
Older children who are in on it are the best Santa's helpers you will ever have. Let them put the carrot out, check the tracker, and answer the little ones' questions. And let them listen in on the younger child's call from Santa: they will enjoy it more than you expect.
What not to do
Do not stage a big revelation, do not make them feel silly for believing, and do not tell them in December. January is kinder.