Use part of a text string to populate another text box

[janerussel]

On my form, I will be requiring a SSN (social security number). I have another text box that will contain the last four characters of the SSN (text field).

How can I automatically populate the four character field from the text in the full SSN.

 

[PHV]

the last four characters
Take a look at the Right function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[janerussel]

Thanks, that worked great!

 

[janerussel]

Here's the code:

Private Sub SSN_AfterUpdate()
Dim AnyString, MyStr
AnyString = Me![SSN]

MyStr = Right(AnyString, 4)

If Me![SSN] > "" Then
Me![SSNShort] = MyStr
End If

End Sub