Please Help, How Do I Format this Data?

[txdave36]

Hey guys,



I have designed report in Access that prints a person's SSN number as 333-33-3333. I would like my report to only show the last 4 digits on the social.

Is there a way to format this directly from the report design? The SSN is a database field in one of my Access tables.

[raskew]

Hi -

Try something like this (example from debug/immediate window)

x = "123-45-6789"
y = "*******" & right(x, 4)
? y
*******6789

HTH - Bob

[RuralGuy]

Welcome Bob,

Glad you found the place. We can use your excellent assistance.

[raskew]

Hi Allan -

It's amazing. Been doing this for how many years? Just now, within the past couple of days, discovered this site.

Best Wishes - Bob

[dcrake]

Hi Bob, I was the same, however you do come across double postings both here and in AWP.

David

[txdave36]

Hi -

Try something like this (example from debug/immediate window)

x = "123-45-6789"
y = "*******" & right(x, 4)
? y
*******6789

HTH - Bob

Sorry, I am a bit green with Access. Where would i type this in?

I've been researching this request all day, and I found this function:

=RIGHT(SSN,4).

I have to enter it into the control source for a text box on my report. Unfortunately, Access complains with a compile error when I try to enter in the function.

I don't get it. The syntax is correct. Here is a screenshot of the error:



Any suggestions?

[RuralGuy]

Try: =Right([SSN],4)
If that does not work then you might have a bogus MISSING reference.