Ok, so I have a SSN field. Right now it displays correctly so that is not a problem. But what I want the field to do is change it's control source based on whether a new record is being added our not.
Currently the control source displays like this:
This displays only the last four of a SSN
But when I add a record I want the control source to go blank, then on the after update I want the control source to display how it would normally.