dashes in ssn

[Joanne]

I have a field in my table for ssn, and I chose 'save with the symbols
in the mask'. The input mask is 000\-00\-0000;0;, and the symbol is
the dash mark.

I want to save the dashes in the ssn, like 333-33-3333 because I will
use this value as a bookmark in a word doc and I want the dashes to
show (and print) on the word doc also.

Is there a way for me to do this other than simply have the user type
in the dashes during data input?
Thanks for your time and consideration of this problem
Joanne

 

[fredg]

I have a field in my table for ssn, and I chose 'save with the symbols
in the mask'. The input mask is 000\-00\-0000;0;, and the symbol is
the dash mark.

I want to save the dashes in the ssn, like 333-33-3333 because I will
use this value as a bookmark in a word doc and I want the dashes to
show (and print) on the word doc also.

Is there a way for me to do this other than simply have the user type
in the dashes during data input?
Thanks for your time and consideration of this problem
Joanne

The final ;0; tells Access to save the hyphens with the data, so you
should be getting what you want.
All the user should do is type in the numbers..
123456789 and the data will store as 123-45-6789.

Do you really want the comma as a placeholder?
An underscore seems cleaner and easier to follow (at least to me).
000\-00\-0000;0;_

 

[Joanne]

Thanks Fredg
I have reset the input mask and will give the whole show a try in the
morning - enough for tonight.

BTW, the comma has been replaced with the underscore - and is easier
to see for sure.

Thank you for answering my question - I really appreciate it.

 

[fredg]

Thanks Fredg
I have reset the input mask and will give the whole show a try in the
morning - enough for tonight.

BTW, the comma has been replaced with the underscore - and is easier
to see for sure.

Thank you for answering my question - I really appreciate it.

Just remember, the input mask will only effect NEW input data. If you
have already existing data stored as 123456789 you'll need to use an
Update query to change the existing data.

Update YourTable set YourTable.SSN = Left([SSN],3) & "-" &
Mid([SSN],4,2) & "-" & Right([SSN],4);

 

[Joanne]

I was sweating that just a moment ago - thanks for the head up, it
makes a ton of difference on how my morning will go ;-)

Thanks Fredg
I have reset the input mask and will give the whole show a try in the
morning - enough for tonight.

BTW, the comma has been replaced with the underscore - and is easier
to see for sure.

Thank you for answering my question - I really appreciate it.

Just remember, the input mask will only effect NEW input data. If you
have already existing data stored as 123456789 you'll need to use an
Update query to change the existing data.

Update YourTable set YourTable.SSN = Left([SSN],3) & "-" &
Mid([SSN],4,2) & "-" & Right([SSN],4);