This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

please increase the points.

Is SSN a 9 digit number with two dashes in between?

Like this: 333-22-4444

The simple formula to encrypt SSN would be then:

FIELD SSN:=SSN;

@If(@Left(SSN;1)="x";"";

@SetField("SSN";"x"+@Repla

Best place for encryption formula would be the Form’s QuerySave event.

For decryption use this formula:

FIELD SSN:=SSN;

@If(@Left(SSN;1)="x";

@SetField("SSN";@ReplaceSu

Because you have not stated when SSN has to be in plain format I can not recommend when to decrypt your SSN.

This was a simple method do hide from first view the content. In most cases that would be enough. Next step would be to recalculate the SSN number before translating. But this is mostly not necessary.

In LotusScript I use much more elegant XOR functions to encrypt and decrypt any ASCII content. But please increase first the offered points.

So long,

zvonko