there is no support for this. You would need to use the change event for the
textbox to validate the entry.

--
Regards,
Tom Ogilvy


"Lloyd" wrote:

Hi My name is Lloyd
I know MS Access quite well, can you help me I want to put input mask to a
date on a field in a form in Excel eg. 2006/08/08.

Thanks