Conditional Inputmask

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!!
 
A

Arvin Meyer [MVP]

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

Top