<div>
Jim,<br />
<br />
That worked. &nbsp;Thank you very much.<br />
<br />
John<br />
<br />
PS still have the coin coming. &nbsp;We had an issue with getting coins. Should be here next wednesday.
</div>


Jim,

That worked.  Thank you very much.

John

PS still have the coin coming.  We had an issue with getting coins. Should be here next wednesday.

<div>
Great solution. &nbsp;Quick and direct to the point.
</div>


Great solution.  Quick and direct to the point.

<div>
<div class="content wysiwyg-content">
Ok, so I have a SSN field. &nbsp;Right now it displays correctly so that is not a problem. &nbsp;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.<br />
<br />
Currently the control source displays like this:<br />
=&quot;XXX-XX-&quot;+Right([SSN],4)<br />
<br />
This displays only the last four of a SSN<br />
<br />
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.<br />
<br />
Thanks<br />
John
</div>
</div>


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:
="XXX-XX-"+Right([SSN],4)

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.

Thanks
John

Changing a fields control source based on the type on input

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.