display part of column data in Access

[xchen88]

Is there any way to only display part of the data in a certain column, for example, SSN 123-23-4566, I would like to display 4566 only.

Thanks

 

[Remou]

You can set the control source for a textbox to:

[tt]=Right(SSN,4)[/tt]

 

[xchen88]

Thanks for the reply. I should have made myselft more clear.
I mean the table, not query. When user opens the table, it only displays part of the data.

Thanks

 

[JoeAtWork]

Well you could do as Remou suggests on a form that is bound to the table.

 

[Remou]

As JoeAtWork implies, users should not have access to tables.