SS# formatting

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Is there a way to conditionally format a social security/tax id# field so
that if a business name field is populated, the ss#/tid# field is formatted
00-0000000 & if the business name field is null the ss#/tid# field is
formatted 000-00-0000?

TIA

craig
 
Craig,
I take it you're storing the SSN/TAXID as just 9 digits with no
formatting. (123456789)
So, you could use the OnCurrent event for the form to...
If IsNull(BusinessName) Then
SSNTaxID.Format = "000-00-0000"
Else
SSNTaxID.Format = "00-0000000"
End if
 
That's what i was looking for. Thanks Al!

Craig
AlCamp said:
Craig,
I take it you're storing the SSN/TAXID as just 9 digits with no
formatting. (123456789)
So, you could use the OnCurrent event for the form to...
If IsNull(BusinessName) Then
SSNTaxID.Format = "000-00-0000"
Else
SSNTaxID.Format = "00-0000000"
End if
Click to expand...
 
Actually, what I was looking for was fixed after i changed the
SSNTaxID.InputMask to = "000\-00\-0000?;;#" or "00\-0000000?;;#" but thanks
for sending me on the right track.

craig
 
Back
Top