Thank you for helping me with the code. I will give this a try when I return to the office.
Joe --- In [email protected], "Liveson Tumbulu" <l.tumb...@...> wrote: > > 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] >
