Only show Last Four numbers of SSN

G

Guest

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

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

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

he fisrt four digits
Left(fieldName,4)
 

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

Similar Threads

Sort Last 4 Numbers of SSN 2
How do I show only the last four digits on a 9 digit field? 1
Compare two tables using last four of SSN 2
Make Table qry - trim SSN to last 4 digits 5
Using the "RIGHT" function 3
Query totaling one field for unique values 2
linking fields which may be incomplete 2
Unmatched Query? 1

Top