masking data in password field in resulting query

[Jeff A via AccessMonster.com]

hi,

i have a query that selects records from the USER table, which returns, among
other fields, the password of the users. i'd like to mask the contents of the
password field with asterisk (*) for each character of the password in the
resulting query.

hope anybody could help.

thanks,

jeff

 

[John Nurick]

Hi Jeff,

Try setting the InputMask property to
Password

But remember this just masks the passwords: a skilled user will still be
able to retrieve and read them.

 

[Jeff A via AccessMonster.com]

thanks for the tip, john. Just would like to know how i could set it in a
query (i won't be using a form to display the query results). thanks!

 

[John Nurick]

In query design view, right-click on the field and select Properties,
then set the input mask.

 

[John Spencer]

Do as John Nurick suggested. (Step by step follows)
Open the query in Design view
Click in the column you want to mask
If the properties window is not open, select View: Properties from the menu
Type the word "Password" into the Input Mask "cell"