Dashes in Social Security Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I need to have dashes in the Social Security Number field of a table. Right
now, all of the socials are without dashes. If I change the Input Mask of the
table, the dashes are not really there. Can I run some kind of an update
query to add the dashes in the socials?

Thanks!
Emmy
 
Emmy, if the field is a text field, you can use an update query and the
following expression to update the field:

Left (SSN, 3) & "-" & Mid (SSN,4,2) & "-"& Right(SSN,4)

Replace "SSN" with the name of your field. I would test this on a couple of
records first before updating all of the records.
 
Thanks! That worked great!!

xRoachx said:
Emmy, if the field is a text field, you can use an update query and the
following expression to update the field:

Left (SSN, 3) & "-" & Mid (SSN,4,2) & "-"& Right(SSN,4)

Replace "SSN" with the name of your field. I would test this on a couple of
records first before updating all of the records.
Click to expand...
 
Hello,

I need to have dashes in the Social Security Number field of a table. Right
now, all of the socials are without dashes. If I change the Input Mask of the
table, the dashes are not really there. Can I run some kind of an update
query to add the dashes in the socials?

Thanks!
Emmy
Click to expand...

After you follow the other suggestions to Update the Table, change the
Input Mask property so that, for future entries, the mask is saved
with the data.
000\-00\-0000;0;_
 
Back
Top