Formatting a Report

[sweetpea58]

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

 

[Smart]

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

 

[Michael J Ross]

already answered

 

[sweetpea58]

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

 

[Michael J Ross]

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