Last 4 of SSN in Field

[clownfish1980m]

I created a database is Access 2007 with the following code. I have a field to put the SSN in and another field to have only the last 4 show up. When I produce a report only the last 4 numbers are used. The code is under "Control Source" , =Right([SSN],4). It doesn't work in 2010. Not sure why or how to fix it. Thanks Ken

[June7]

What does "doesn't work" mean - error message, wrong results, nothing happens?

Are you saying the expression in ControlSource is not calculating?

Why don't you do that calc in query then bind textbox to the constructed field?

[Bob Fitz]

..."It doesn't work in 2010".... isn't much to go on.
In what way does it not work. Do you get the wrong data, no data, an error message? Where are you using the expression?

[clownfish1980m]

It gives me #Name?. It worked in 2007 version but not in 2010. Does VBA work in 2010? Ken

[June7]

Certainly VBA works in 2010. But what does VBA have to do with expression in query or textbox? Did you try my suggestion to calculate in query?

I have found that if a report textbox is not bound to a field, referencing that field in an expression can fail. I know, weird, but that is what I experienced.

Also, if the textbox is named SSN and its ControlSource has expression referencing SSN, that is circular reference and will error.