Input Mask Question

[Elizabeth.Emerson]

I have an upcoming project where we will be collecting tax parcel data,
each of our counties report tax parcel information in different ways,
i.e.:
County A - LL00-000.00-00-00.00
County B - 000-0.00-00-00
County C - 000.00.00-00.00
I would like to store all the tax parcel information in one field but
have the input mask based on the county chosen. I have created a look
up field for the County (strCounty) and another field for the Tax
Parcel Number (strTaxP). I am not sure the best way to go about this
if it is even possible, any suggestions would be greatly appreciated.

 

[Guest]

Use the Form's Current event to set the input mask depending on the county of
the current record:

Select Case Me.txtCounty
Case Is = "A"
Me.txtParcelID.InputMask = "LL00-000.00-00-00.00"
Case Is = "B"
Me.txtParcelID.InputMask = "000-0.00-00-00"
Case is = "C"
Me.txtParcelID.InputMask = "000.00.00-00.00"
End Select