help with string issue

[Kaspa]

Hello,

I have a field that contains a social security number, I would like to
add the character "|" after each digit and display it in a report like
5 | 5 | 5 | --| 5 | 5 | --| 5 | 5 | 5 | 5 but I am having trouble with
this anybody would please help. I have tried this:
=Left([SocialSecurityNumber],1) & " |" & Left([socialsecuritynumber],2)
& " |"

but that dos not work.
Kaspa

[pietlinden]

set the input mask of the control to something like this:

0\|0\|0"|-|"0\|0"|-|"0\|0\|0\|0;;_

[Kaspa]

I wanna do it at the report level, is there any function that allows me
to to do this? I iwanna store the social security number like this
111111111 and the out put it in the report like this
1|1|1--|1|1--|1|1|1|1 Please help.

[pietlinden]

Kaspa wrote:

I wanna do it at the report level, is there any function that allows me
to to do this? I iwanna store the social security number like this
111111111 and the out put it in the report like this
1|1|1--|1|1--|1|1|1|1 Please help.

So use the input mask property of the control on the report. Just copy
and paste the mask from the table to the report and you're done.