Displaying Social Sec # with - in between

[paul123456]

I have a report and i want to include the social security number in it but it is displaying as 000112222 how can i get it to display like 000-11-2222?

Thnx in advance Thanks, PAUL

 

[3587]

Try using the Format function on your record source. For example; =Format([SSN],"###-##-####&quot

 

[paul123456]

When i change it to that for some reason after i click off of it it changes back to "#-#-#"

The following is my text code

=[First_Nm] & " " & [M] & " " & [Last_Nm] & ", SSN: " & Format([SocSecID],"###-##-####&quot

But like i said when i do this after i click off of it it changes it to "#-#-#"? on my record source it is based on a query. Thanks, PAUL

 

[3587]

Sorry Paul, change the # to 0 (zeros)

 

[Garridon]

You can also try putting an input mask on the field from the field's properties. That should display the hyphens.

 

[paul123456]

Thank you 3587 works great Thanks, PAUL