Dashes in Social Security Number

[Emmy]

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

 

[SusanV]

SocialSec = Format(SocialSec, 000-000-0000

 

[xRoachx]

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.

 

[Emmy]

Thanks! That worked great!!

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.

 

[fredg]

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

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;_