Sorry I hit Send button accidentally
You can set the fields' Input Mask to Password if you want to conceal whatever is entered in the fields. HTH Liveson From: [email protected] [mailto:[email protected]] On Behalf Of Liveson Tumbulu Sent: Monday, 29 March, 2010 10:47 To: [email protected] Subject: RE: [ms_access] Data Validation on the form Importance: High Joe This should work whether in Access 2007 or earlier. If I get your question right here is what I think you need to do assuming you are familiar with Visual Basic for Application (VBA). In DL2's BeforeUpdate event put this code If DL2 <> DL1 Then DL1 = Null DL2 = Null Cancel = 1 DL1.SetFocus End If The above code will clear whatever was entered in DL1 and DL2 if it is found that the two are not the same. You can set the fields' HTH Liveson From: [email protected] <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> ] On Behalf Of feihu_aiwei Sent: Sunday, 28 March, 2010 18:29 To: [email protected] <mailto:ms_access%40yahoogroups.com> Subject: [ms_access] Data Validation on the form I am working in Access 2007 and creating a database to keep track of our volunteers for our C.E.R.T. Group. There is some information that I am requesting that is semi confidential, so when it is entered, I don't want do display it on the screen, but I need to make sure the first field is identical to the second field. The end user only has access to the forms. My query is built off my table. The field names that need to be compared are: DL1 and DL2. Once focus is removed from DL2, I want to compare both fields to make sure they are identical. If they are not, I want to clear both fields and return focus to DL1. How can I accomplish this? I am sure I need to do my validation on the form, but not sure how. Thanks Joe [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
