>I am creating a program that requires one of the field to be encrypted on the sql server. I need to be able to store weither or not the program has been registered and I don't want the user to beable to just open the table and see what's needed to register the program. Is there a way to encrypt a field in a table. Is there some trick that I could use to do this.
>
>Thanks

What Barbara said. What I do is include the Sys[2007, expr] function and convert the return value to a number [integer], do some additional math add some number, square it, subtract a number, etc. I also have a special textbox class that I have a custom property that I store the tablename.fieldname in. This text box refresh, decrypts the value and uses that for the textbox value property. The LostFocus re-encrypts the value and replaces the TableName.FieldName with the new encrypted value. Actually, the Refresh and LostFocus calls my Encryption/Decryption function in my application class.