Multiple Input Mask

[RHorton]

Hi,

Can anyone tell me how I can format my access tables with multiple input masks under one field?

In my table I have formatted my telephone numbers so that they read (xxx) xxx-xxxx which suits our predominantly UK based business telephone numbers, however we also have a lot of Irish numbers which follow a different configuration e.g. (xxxxx) xxxx-xxxx - how can I add this second input mask so that both formats are recognised within the same column/ field?

Many thanks
RHorton

 

[neileg]

You can't.

But you could write your own validation in VBA in a data entry form.

 

[RHorton]

Cheers Neil,

Thanks for that - I am very new to Access (as in, finished some basic training on Friday) and pretty much need all the help I can get!!!

Thanks.