Skip to content
Sign in
Artwork for Computer Learning Zone
Computer Learning Zone · Monday · 3 min

Microsoft Access Password Prompts and Hidden Input Options

Can Microsoft Access hide password characters typed into a standard InputBox? This quick quiz explores why the built-in InputBox cannot display asterisks and why a custom form with a password-masked text box is the better choice when users need a more polished password prompt. Along the way, it covers practical Access macro design: keeping shared passwords in a settings table, using DLookup criteria to retrieve the correct value, and making sure OpenForm runs only after the entered password matches the expected one. It also includes an important security reality check. A password prompt can protect a menu path, but it does not secure every route into a database, especially when a plain-text password remains accessible in a table or the database design.

0:00-3:50
Play in

transcript

No transcript — this publisher did not publish one.

show notes

Can Microsoft Access hide password characters typed into a standard InputBox? This quick quiz explores why the built-in InputBox cannot display asterisks and why a custom form with a password-masked text box is the better choice when users need a more polished password prompt.

Along the way, it covers practical Access macro design: keeping shared passwords in a settings table, using DLookup criteria to retrieve the correct value, and making sure OpenForm runs only after the entered password matches the expected one.

It also includes an important security reality check. A password prompt can protect a menu path, but it does not secure every route into a database, especially when a plain-text password remains accessible in a table or the database design.

more episodes

All episodes