Conditional Inputmask

  • Thread starter Thread starter paduanow
  • Start date Start date
P

paduanow

I am using an option box (2). One for Social Security Number(SSN) and the
other is for a EIN number. Both boxes cannot be selected at the same time.
If SSN number is selected I what the field TaxID to have an InputMask of
000-00-0000, If EIN is selected i what a InputMask for the field TaxID to
have 00-0000000.

I tried several methods time using IIF but nothing work. Any Help!!
 
Use a Select Case statement something like (air code):

Private Sub optTax_AfterUpdate()

Select Case optTax

Case 1
TaxID.InputMask = "000-00-0000"
Case 2
TaxID.InputMask = "00-0000000"

End Select

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula 7
How can you Force "0s" in the field 4
Show Button 3
Date Picker with Inputmask 3
inputmask in VBA 1
Listbox Value 2
Need help with inputmask *752008 1
SQL Problem 2

Back
Top