Input Mask Question

  • Thread starter Thread starter Elizabeth.Emerson
  • Start date Start date
E

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.
 
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
 
Back
Top