1. Home
  2. MS Office

Assign Password Data Type To A Specific Field In Access 2010

Applying different types of constraints over data fields in Access 2010 comes in handy, especially when you need to restrict database users in specified range. Applying Data types over fields plays vital role in manipulating data in a desired way, but way of assigning data type as password is bit different as you need to add input mask for it. In this post we will show how to assign password data type to a specific field.

To begin with, launch Access 2010 and create a new table, navigate to Create tab and click Table.

create table

It will create table namely Table1.

table 1

Right-click newly created table and click Design View.

design view 1

Now enter appropriate table name and click OK.

save as 1

Start entering table field names; Login Name and Password. Now we will be changing Data Type of field Password.

login design view

Select the Password field and under field properties, from Input Mask, click small button at the end of the field, a message box will pop-up asking for saving the table first, click Yes to start a input mask wizard.

input mask

In wizard, from list of Input Mask, click Password and click Next to continue.

select passwordf

Now click Finish to end the wizard.

click finish

You will see Password data type inserted as Input Mask. Now close down the design view and save the changes made.

password 1

Open the table in datasheet view and start entering the login details and Password. On entering password, you will see asterisks concealing the password text.

login details

You can also check out our previously reviewed guides on How to import XML file in Access & Export database to PDF document.


  1. I would like to use this solution but then how do I actually view the passwords when I need to? Deleting the input mask every time i need to get a password seems like too much work.

  2. the point is you might be working on your database and somebody may just accidentally look at it and see some passwords. they why you need to cover your ass

  3. i dont understand the point. if any third person wants to view the password he can easily view it by removing the input mask so whats the point of using the password data type?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.