Input mask for SSN in database (1 Viewer)

[rjkimme]

I am not sure of the input mask to include for the input of a SSN. I want to appear as: 555-55-5555 I have selected it to be a long integer. Is that also correct?

 

[rjkimme]

Also looking for the format for a phone number: (___)___ - ____

 

[KeaganQuilty]

Actually both fields should be text. Change your fields to text and then click the build button next to the InputMask Field. SSN and Phone Number should be there waiting for you

Keagan Quilty
Kilbride, Newfoundland

 

[rjkimme]

Thank you for your response. Unfortunately many of the wizards are not working on my system. Seems to be a conflict between microsoft and UNIX. Anyway you could post the formats here?
Thanks

 

[DJN]

Have a look at the help file under input masks. There are some good examples. In the meantime you could try the following.
(000) 00-000 and 000-00-0000 The zeros are for digits between 0 and 9