Hey Everyone,
I have a Report that contains SS#'s that I don't want visible when I view and print the report. Is there a way to just hide some of the numbers so that, only the last four digits are visible. I would use the visible property format but that would hide all the digits. Can anyone help?


Thanks:o

In the query that the report is based on ad a new column

shortened: Trim(Right([fieldname],4))

then in the report base the field you wnt to print (with shortened number ) on the field shortened

already answered

I dont think i got this, could u explain a little more in details

Another way you could do it is to put in the Control source of your SS# field = Right(Trim([nameofyourfield]),4)