G Guest Nov 19, 2005 #1 I have a form that shows SSN, but I want to limit what the cell shows to just the last four. Any ideas?
I have a form that shows SSN, but I want to limit what the cell shows to just the last four. Any ideas?
D Duane Hookom Nov 19, 2005 #2 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.
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.
G Guest Nov 19, 2005 #3 To get the last four digits use the right function Right(FieldName,4) he fisrt four digits Left(fieldName,4)
To get the last four digits use the right function Right(FieldName,4) he fisrt four digits Left(fieldName,4)
