Somewhere between seven and ten, most kids start asking. A classmate has said something, the handwriting on the tags looks familiar, or they have done the math 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 kids, 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 kid who is wondering is reassured by evidence that does not come from you. NORAD showing the sleigh over the Atlantic. A letter with a North Pole return address. A phone call where Santa says their name, mentions the thing they did well this year, and listens to their answer. Kids who have had Santa call 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 kid 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 kids take it very seriously.
The little ones
Older kids who are in on it are the best Santa's helpers you will ever have. Let them move the elf, set out the cookies, 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 reveal, do not make them feel silly for believing, and do not tell them in December. January is kinder.