Only show Last Four numbers of SSN

[franklinbukoski]

I have a form that shows SSN, but I want to limit what the cell shows to just
the last four. Any ideas?

 

[Duane Hookom]

Maybe:
=Right([SSN Field Name],4)

Make sure the name of the text box is not the same as a name in your
report's record source.

 

[Ofer]

To get the last four digits use the right function
Right(FieldName,4)

he fisrt four digits
Left(fieldName,4)

 

[franklinbukoski]

Duane/Ofer: Just like Excel! It didn't even occur to me, thank you!!!