From: albert.repasky on
I have a field for Employee ID. I need to have the field have 3
different input masks. Can I do this in the table or do I have to do
this on the form and an event? If on an event, which event should I
use? The click event?

Thanks,
Arep
From: Duane Hookom on
I don't generally use input masks. However, you might need to do this in the
form control. The event used to set the different input mask depends on your
business rules. We don't have any clue regarding why you need three or what
triggers this.
--
Duane Hookom
Microsoft Access MVP


"albert.repasky(a)bnymellon.com" wrote:

> I have a field for Employee ID. I need to have the field have 3
> different input masks. Can I do this in the table or do I have to do
> this on the form and an event? If on an event, which event should I
> use? The click event?
>
> Thanks,
> Arep
>