mask input box when typing password

[chubbychub]

hi, i have a file and to 'unlock' a sheet, i have a password as '123' but i need to hide this when typing in, or mask it when typing in the password as it shows the character when i type it in, i have attached the file with dummy data. please help, thank you. i tried to google, but google just send me to stray other subjects because of my lack of knowledge with access.

[kd2017]

https://access-excel.tips/password-text-box-mask/

[isladogs]

I've not checked the previous lin but here is a version that works in both 32-bit and 64-bit Access
Masked Input Box (isladogs.co.uk)

[chubbychub]

Is it possible for someone to actually do it for me? i dont have any experience at access at all, and dont know what i am doing, googlin and googling and stray away from my objective. Thanks in advanced.

[moke123]

Did you even look at the link in post#2?

Even has pictures

[chubbychub]

yes, but when i go to the 'Data' tab, i dont see anywhere it says 'input mask' i dont even have that option when i click on property sheets

[davegri]

yes, but when i go to the 'Data' tab, i dont see anywhere it says 'input mask' i dont even have that option when i click on property sheets

Do this:

[chubbychub]

is that in the sample file i uploaded? i dont see any of that from the tutorial in the sample file ( i dont even know where to find the inputbox) i been looking on the forms, can somone look at the sample file please?

[davegri]

All the suggestions here are assuming your input is typed into an Access form, however your sample download is using an inputbox for the password. I don't think there's a way for native Access to mask that input. Maybe you could do it with a Windows API.
Scrap the inputbox and use a normal Access form.
Also, you should present your data to the user with a form, not directly via an open table or query.

[chubbychub]

is there a way you can do it for me on the sample sheet? i dont know how to do it and dont really understand enough. I mean i odnt use it for anything else, and not really familiar with vba. I just got that code from google because it worked, and that was a milestone for me. Thanks in advanced.

[Welshgasman]

Most people would use a form and a textbox?

[isladogs]

As already suggested, it isn't possible to do this in an input box without code
However if you look at the link I provided in post #3, all the code needed is supplied together with an explanation of how to use it.

Whichever approach you use, you need to do the small amount of work needed yourself or you will learn nothing.