MS Access VBA Substitution Cipher Encrypt/Decrypt

Could anyone suggest please how I can achieve a substitution cipher style; encrypt and decrypt function in VBA. I appreciate hashing is considered the better way but I need reversible encryption. Many Thanks.

How do I encrypt text in VB net?

There's a text box, an "encrypt" button, and a "decrypt" button. The idea is to type something into the text box ("like 'hello world'"), click "encrypt", and see the encrypted version appear in the text box.

How do I encrypt a text file?

Right-click (or press and hold) a file or folder and select Properties. Select the Advanced button and select the Encrypt contents to secure data check box. Select OK to close the Advanced Attributes window, select Apply, and then select OK.

You can use Blowfish. There's a Visual Basic 6 version that will work in Access, available here:

http://www.di-mgt.com.au/cryptoBlowfishVer6.html

You can also try TwoFish.