How Can I Format a Data Field on a Report?

[txdave35]

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

 

[PWise]

How about

Right(ssn,4)

or

"***-**-" & Right(ssn,4)

 

[txdave35]

Where would I enter this? Tried putting it in the FORMAT properties, but it did not do anything.

 

[PWise]

put it in the control source of the ssn Textbox

 

[dhookom]

You would need to add an equal sign to the left of any expression that isn't a field name. Also, make sure the name of the text box is not the name of a field in the report's record source.

  =Right(ssn,4)

Duane
Hook'D on Access
MS Access MVP