Using MS Access/Password font

Advertisement


Question
Dear Julie,
I've created a vba code that has an Inputbox variable. this variable is asking for a password.
What should I do to set a password font to this variable? so the value entered will be hidden.

Thank you in advance.
Maya

Answer
Hi Maya,

Thanks for the question.

Sorry this is not possible (easily).

The options you have are to create your own form that acts like an input box.  And set the textbox control's InputMask property to "Password".

or

I did find some code to assist you if you wish to continue with the input box.

http://www.access-programmers.co.uk/forums/showthread.php?t=176711

Hope this helps.  

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Julie Misson

Expertise

My area of expertise is Microsoft Access 2000-2007. I have been building microsoft databases for the past twelve years. I would be competent in answering questions from novice Access 2000 users to the more advanced including VBA. If I cannot help, I am more than likely be able to point you to websites that can.

Experience

I have a Microsoft Access business where I build database for small businesses. These are usually one off designs, where there is no off the shelf software avaliable to meet the business needs. I also teach Microsft Access to beginners. I am the owner of the www.simply-access.com website.

Education/Credentials
Self taught in Microsoft Access. Have done some units in normalisation and SQL, but most of what I know I have learnt from books originally and more recently the Internet.

©2016 About.com. All rights reserved.