Part 1 – Designing Ultimate Login Form in Access

There can be several ways to design a login form in Access but to keep it professional and modern-looking, here is a step-by-step guide. Please watch the complete video tutorial to design the Ultimate Login form in Access.

What are the steps to design the Ultimate Login Form in Access?

1. Blank Access Database and Form Elements

Start Microsoft Access and create a New Database file.

Select Form Design from the Form Create menu

There is no need for Form’s header or footer for now

Draw 2 rectangle boxes side by side with different widths but the same highest

Bring 2 Text Boxes from the Form Design menu and align the Label accordingly

There are several web platforms to download Icons. Download suitable icons for Username and Password. The recommended platform is Icon8

Create a Button and change its caption to Login from the Format section of the Property Sheet

Copy the Username textbox and create 2 more textboxes related to New Password and Verify Password

Create 5 more buttons by simply copying the Login Button. These are the captions of the buttons:

• Change
• Change Password
• Forgot Password
• About (Optional)
• Contact (Optional)

Create a label to show the error message when New Password and Verify Password do not meet the criteria of 8 characters length.

2. Define unique names for all elements

All objects must contain unique names including text boxes, buttons, and labels.

Unique names of the Login Form elements

Unique names of the Login Form elements

3. Textbox Placeholder and Conditional Formatting

Apply a placeholder in the text boxes to enter below in format.

To look placeholder professional, use Conditional Formatting along with the Expression Builder by following these steps:

• Select the Username textbox and click on Conditional Formatting from the Format menu
• Click on New Rule
• Select the “Expression is” option from the drop-down
• Open the Expression Builder
• User the “isnull” function containing the Username
• Apply a dim gray color and the font style as italic

isnull([txt_username])

4. How to apply Password Mask

Select the Password textbox and expand the Input Mask Wizard from the Data section of the Property Sheet.

Select the Password option which contains asterisks and hit Finish

5. Hide and Unhide the Change Password section

Hide these 4 elements by selecting and changing the Visible option to No from the Format section of the Property Sheet:

• txt_newpassword
• txt_verifypassword
• Lbl_chage
• btn_change

Apply this code to the Change Password button by selecting Code Builder from the On Click Event of the button

Private Sub btn_changeclick_Click()

Me.txt_newpass.Visible = True
Me.txt_verifypass.Visible = True
Me.Lbl_password.Visible = True
Me.btn_change.Visible = True
Me.Lbl_newpass.Visible = True
Me.Lbl_verifypass.Visible = True

End Sub

Apply this code to the Forgot Password button by selecting Code Builder from the On Click Event of the button to show a message popup:

Private Sub btn_forgot_Click()
MsgBox "Please contact with Administrator !", vbExclamation, "||| Forgot Password |||"
End Sub

The Login Form of the Ultimate Login System should be finally something look like this: