It may mean following links and reading a lot more than you want to but hans_v gives the best advice. Their detailed sample tells you that altough combining splits will work.
This article explains how to use validation rules and validation text in table fields and form controls.If possible, I would like to use VBA / Windows API code to validate the password that a user keys in against their Windows password, but I have searched for days on how to accomplish this. Unfortunately, this does not help me since it is for web-based ASP.net, Forms authentication, cookies, etc.I can easily validate their username, just not the password. I am looking for a simple method possibly using a combination of VBA with Windows API inside my Microsoft Access database application to validate a user's keyed-in password with the password they use to login to their Windows account. " id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="5459017" / Thanks for pointing me to the KB article: How to authenticate against the Active Directory by using forms authentication and Visual Basic . Unfortunately, this does not help me since it is for web-based ASP.net, Forms authentication, cookies, etc.The one I am going to demonstrate must not be the best, but will fulfill your basic requirements.Create a table that store the verification information.On my database, I setup a table tbl Worker that has a User Type field links to a table tlb Security Level.So the data type of a User Type field is number because it refers to the Security ID (Autonumber) in the tbl Security Level table above. Then customize the form such as resize, change caption or name form. Input two text boxes in the Login Form as txt User Name with label Login ID and txt Password with label Password 5. A little donation is much appreciated ..................... Set a Login Form as a display form when open a database program on the Quick Access Option: 8.You can create the User Type field from the Lookup Wizard on the dropdown of Data Type column. Under On Click Event of the Cancel button, add the Embadded Macro with a Quit Access command to exit the program or Access application 6. On the Navigation Form, create two textboxes and name it as txt Login and txt User.Under On Click Event of the OK button, add the VBA code below under the Event Procedure Private Sub Command1_Click() Dim User As String Dim User Level As Integer Dim Temp Pass As String Dim ID As Integer Dim worker Name As String Dim Temp Login ID As String If Is Null(User Name) Then Msg Box "Please enter User Name", vb Information, "Username requeired" User Name. If the Login ID and password are correct then will open Navigation Form and pass the Login ID to txt Login and pass workername to txt User with code below: 9.You can only prevent any unauthorized person running the Access application on other person's computers." id="ctl00_m_m_i_ctl00_gr_ctl05_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="5459053" / You may not be able to retrieve Windows login password.If any application program can easily access login password it can make the system very unsafe. You Access database is not really protected if you are using Windows login account and password.