>>if I encrypt a memo field in a table using vfpencryption.fll
>>what is the best way to show the data in a screen? what method is best to handle the derypt/encrypt functions?
>>

>
>that really depends on how you code. One way would be to decrypt it when you query the data. Another way would be to decrypt it in your Business Object code. Yet another way would be to decrypt it in the control's refresh. Or if your form has a method that always gets called when a new record is displayed you could use that.

i think it should be in the UI so only a person having access to a particular form can actually have it decrypted.
using that logic if I decrypt in the gotfocus() it displays plain text (good)
then if I encrypt it in the lostfocus() it' be encrypted when saved bau also the display shows garbage

to refine my question, is there a way in a edit control to ALWAYS show text while the actual data behind is encrypted??


Peter